Multiple Columns to Rows in Excel

[siddll]

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?

[#2 · Accepted solution]

@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.