Hello,
Looking for some help with Power Query please.
On the attachment I have data that I compile using PQ to pull workbooks together (tab 1).
I need the format to then look like tab 2 data.
I have tried pivoting and unpivoting in pq and cannot figure out how to transpose the data into the format I need.
Your help is appreciated.
thank you
This proposal combines power query and power pivot
1. Convert the data in A1:F25 into an Excel table.
2. Load the table into power query and apply the following code:3. Close and Load to: only connection and add to data model
Please Login or Register to view this content.
4. Add the following explicit measure to the data model: Value Text:=CONCATENATEX(Values(Table1[Value]),Table1[Value],", ")
5. Produce a pivot table from the data model with Vendor and Category in the Rows area; Report Date(Month) in the Columns area and Value Text in the Values area
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
That works thank you.
You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks