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 | Y | N |
When we create a pivot table and add up the columns "Is Customer Registered?" and "Is Customer Active?" to the Fields, we see a combination of it. However what is required is in the format
Is Customer Registered?
Y
N
Is Customer Active?
Y
N
Unfortunately this is not the format we get the data in. Any help?
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.
