
Power Query
Power Pivot

July 11, 2016

Hi,
I have a file that contains product specifications. The specifications are for different categories. The category headings are in one column and their value is in another. There are multiple rows of data for each product. The number of categories for each product can vary.
I have attached an example file that shows the source data and an example of the result required. What I need to do is get the values in the Category field to be column headers and then have the data from the Value column appear in the columns. When I try to pivot or unpivot the data I can get the column headers but the values appear as 0 or 1 not the actual data values.
Is there any way to do this in Power Query?
Thanks
Mark

VIP

Trusted Members

December 7, 2016

Hello Mark,
In Power Query Editor, select the Category column and in Transform menu, click Pivot Column.
In the dialogue box, pick Value as the column that contains the value data and click on Advanced options and select Don't aggregate in the drop down list.
Click OK and you have your data as you want it.
See attached file for an example.
Br,
Anders

Answers Post

VIP

Trusted Members

December 7, 2016

1 Guest(s)
