Create a table/pivot table using different items items from a column

Hi Stevetton,

You've got the right idea with posting your file & adding snapshots to your post but they don't help me much unfortunately.

This is because I need to see the same data in the 'Before' & then in the 'After' shot to see what you mean.

Example, if You have a Product like 'Bartlett Low Leg Small Stool', lets see that info changed in the 'After' view, at the moment I can't compare.

If possible, create another workbook with separate worksheets with the 'Before' data & then the 'After' data shot showing the same data elements.

If you can do this I might be able to help.

Cheers