transform table

  1. T

    Pivot/unpivot help

    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...
  2. G

    PowerQuery - Modify data

    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...
  3. W

    How To Convert Horizontal List To Vertical List?

    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...
  4. M

    Partial Transform

    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...
  5. M

    Transform multi-level table format, maybe with pivot table?

    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...
  6. B

    Having to restructure table to a strange format, need ideas on how to do it in bulk

    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...
  7. S

    Calculating count of 1st occurrence of ACV value in crosstab rows containing variable date headings

    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...
  8. M

    Transform Rows to columns

    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...
  9. E

    PowerBI refresh fail - Expression Error.

    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...
  10. K

    Transforming data

    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've detected that you are using an adblocker.

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.
Go back
Back
Top