Forum Discussion
Solved
Multiple Columns to Rows in Excel
Need to get multiple Columns under row level in the Pivot Table. Example data that you can make use of Customer ID Is Customer Registered? Is Customer Active? 1 N N 2 Y Y 3 ...
siddll Perhaps something like in the attached file?
I flattened the data with Power Query and then loaded it directly into two example pivot tables. Does any of this meet your requirements? If not, please clarify how you want the result to look like.
siddll Perhaps something like in the attached file?
I flattened the data with Power Query and then loaded it directly into two example pivot tables. Does any of this meet your requirements? If not, please clarify how you want the result to look like.