How do I combine Excel pivot table Rows?

378 Views Asked by jkstallard At 23 March 2023 at 13:04

Say I have a basic table of data with 1 question asked twice (once before, once after to compare responses).

I do a pivot table on this data and i get:

However, I want to combine the Rows, so it looks like:

There are 0 best solutions below