Forum Discussion
Row to Column Formatting for 5K Unique Rows
Hello, What I'm trying to do seems simple but not when I try to 5K unique IDs. I have 5k hospitals all in row format. Each hospital has procedural volumes (counts) for 33 different procedures, with ...
Hi! I will try something for you... in meantime pls check if you can change first table into pivot table.
Thank you!!
Yes, I have tried creating a Pivot Table on the original file, but what I cannot figure out from there is how to get the 33 procedures repeating down the one column I need (Procedures Column)
With Power Query that is two steps job - you query your table, select first two columns, unpivot other columns and return result back to Excel sheet.
Please see in attached file.
