Log In
Register
Home
Power Query
July 11, 2016
Offline
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
See Answer
VIP
Trusted Members
December 7, 2016
Offline
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
Power Query
July 11, 2016
Offline
Hi Anders,
Exactly what I needed. I knew it was possible but was missing the Don't aggregate values piece. Thanks for taking time to provide an answer, greatly appreciated.
Thanks
Mark
VIP
Trusted Members
December 7, 2016
Offline
Hello Mark,
Thanks for the feedback. It is just a pleasure to be able to give some help.
Br,
Anders
New Member
December 9, 2020
Offline
i have the similar case which i already created a separate topic.
This one doesn't seem to work maybe because i have a different format? much appreciated if you can also help on mine Anders, thank you very much.
1 Guest(s)
