Hi
Using PowerQuery I want to transform the first table into the second so that every 'Number' in a 'Region' shows every 'Location' in that 'Region', with multiple rows per 'Number'. This is just dummy data.
I have tried doing this with pivot/unpivot but struggling to get my head around it...
Hi all,
I have a raw data that stores invoices per month. Next month will add 2 more columns for invoice for that specific month (see below example of my raw data).
Column D and E - invoice for June 2021
Column F and G - invoice for July 2021
ABCDEFG1CountryNovationDateRegionPI Value...
Hello,
I have a table that contained, below, I want to transform table like this, is that possible to make with vba or using formula? Thanks for your help.
Original table below:
Line_Name
Stock_code
22.06.2022
23.06.2022
24.06.2022
K9-CMF1 TUBE GUIDE
9813924080
1725
1976
1579
K9-CMF1...
I have a table of orders where the items in the order are all on one line. I need to have each item on its own line along with the order number and date. Some orders could have up to 253 items but of course, I do not want to transform the ones that are blank. Power Query got me very close but...
I have an Excel 2016 file with a large set of panel data in the following actual form:
<tbody>
VAR
ISO
VALUE
1990
1991
1992
IMPORTS
ARG
1,287
NA
NA
IMPORTS
AUS
9,178
447
10,792
IMPORTS
AUT
NA
NA
1,325
GDP
ARG
153
206...
I have a set of data as shown in the table below that I need to showcase in the format as shown in the 2nd table.
But a little background first: In the table below we used a typical format for customer data, where each unique combination of data had its own row, so if Customer 12345 had US...
Hi,
I have multiple crosstab workbooks like this, each representing ACV data for a particular Category-Country e.g. Foods-US. The workbooks filenames are e.g.
INO-Food-US.xlsx
INO-Pet Food-US.xlsx
INO-CCare-US.xlsx
INO-CCare-UK.xlsx
INO-Food-UK
etc.
i can loop thru the folder and import all...
Hi!
Please help me with my thesis research. I have downloaded huge data set to analyse.
For the first step, I want to transform the data. I want dates to be in the rows, and company names to be in the columns.
Currently it is like this;
Name Date Price
Company A...
Hi,
I am unable to refresh my powerbi data online since the last update. Have checked and made sure my personal gateway is up and working. Other Datasets working ok as well.
Have one dataset that is reporting an error
Data Source Error: [Expression Error] The name...
Hi guys!
I came acroos a problem.
I have data in this form:
<tbody>
Region
Salary
1
1000
2
2000
3
3000
1
1500
2
1700
</tbody>
I would like to transform them into this form
<tbody>
Region 1
Region 2
Region 3
1000
2000
3000
1500
1700
</tbody>
Is there any easy way?
Uros
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.