Thread: Fill in a pivot table

Hi,
I tend to use pivot tables a lot. I find them useful.

My question is, How do I create a pivot that fills in all the data on the ROW LABELS side.

For example, I use make and model of cars regularly. I put Citroen in the first row label, followed by the model in the next column.
So it looks like this:
Citroen Berlingo
Dispatch

I want it to look like this:
Citroen Berlingo
Citroen Dispatch
How can I make it filled in so each line has the make and model? My example is attached.

I want to have all the data in each cell so I can analyze data further. Any advice is greatly appreciated.

Thank you,
Chris