MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pivot Tables Displaying Data Columns side by side

Posted by Vivi Hanson on September 15, 1999 12:52 AM

I would like to be able to display the result of two data columns side by side, rather than underneath each other. Is it possible?

Posted by Dave on September 28, 1999 2:16 PM

You can achieve this by dragging the grey data field up and to the right slightly. (If you don't have enough room, insert a row or two at ROW A.
See examplse of what it will look like at Mr Excels site,

Posted by Vivi on October 08, 1999 12:37 AM

Hi Dave - you're a star!! Thanks very much. sorry i didn't reply earlier, but was on holiday.
Thanks again - Vivi