Hello-

I have a set of data that I'm trying to make easier to read.

In doing so I'm trying to pull 1 field (as a row) and then have multiple other fields show as rows under that 1 row, but without rolling up into one another.

See example, below.

2022-04-04_15-43-53.jpg

2022-04-04_15-45-52.jpg

Ideally, I want the Pivot Table to have 5 Main Rows (Example Sys 1, Example Sys 2, Example Sys 3, Example Sys 4, Example Sys 5). I then want 4 rows under each of those main rows (Is your system running slow, is it having issues, what is your associate's sentiment, additional feedback) BUT I don't want these 4 rows to fall under one another- I want them all to fall under the 'main' row equally. The goal is to be able to group the 4 sets of feedback under each 'Example System' for easy reading. I also want each of the 4 groups of feedback to have headers, the headers being the the 4 questions (slow, issues, sentiment, and feedback). That way- whoever is reading this table can easily see a breakdown of each system and the feedback it received.

But as you can see, when I put them all as 'Rows' then roll up into one another (instead of all being 'equal' under the Example Sys. They also don't have a header stating what the answer is to. I'm not super familiar with PivotTables and can't seem to figure this out for the life of me!