Hi all,
I would like to pivot this table so
- each unique value in column Months/TAGS will be a columnheader and
- each columnheader (besides Months/TAGS) will be a row value in the 1e column (and state the totals per column)
Can someone help me with this in Power Query? (I'dont want to solve this with a regular Pivottable)
T pq.JPG
Attached you find the excel sheet with both tables (Table1 and Table2)
Thank you in advance.
Last edited by mamaexcel; 01-12-2024 at 10:25 AM.
Your attachment doesn't work for me, but it looks like you basically need to unpivot all columns other than the first one, then repivot on the Month/Tags column.
Remember what the dormouse said
Feed your head
Hi Rory,
Can you tell me what's not working in my attachment?
I've been trying to accomplish what you suggest but I'm not experienced with PQ so I can't figure it out.
Can you assist me with it?
Do you still use Excel 2016?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
If you have the lastest (beta) release of 365:
=HSTACK(TRANSPOSE(Table1[#Headers]),TRANSPOSE(GROUPBY(Table1[Month/TAGS],Table1[[OKT]:[DEC]],SUM,0,0)))
With PQ:
Please Login or Register to view this content.
Last edited by AliGW; 01-13-2024 at 06:14 AM.
I'm on Office365 now (will update my profile, thanks)
Your formula works great, thank you!
I will keep this in mind for future use or if it's not possible to solve my need in PQ.
For this issue it's not really practical to use it as Table1 is actually not plotted on a worksheet (no need for) so Table1 it's just referenced in PQ.
I gave you the PQ solution as well. If the table is connection only, just change the source of the query.
Please update your forum profile.
My apologies, I just copied your formula in my workbook and overlooked that you had added your version with the PQ code as well.
And yes, that is exactly what I was looking for. Lessons learned.
Thank you so much for you help, I really appreciate it.
Best regards,
mamaexcel
Glad to have helped.
If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.
Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks