Hi,

I had threee different spreadsheets. I copy pasted them all into one spreadsheet as 3 different worksheets so I can pivot.
All these three worksheets have their dates. Formatted the same way.

I want to pivot some columns for worksheet A, some from worksheet B and C and match them against their dates. Basically, I want to do this exactly from this tutorial but on Mac Excel 2011. The order number in the tutorial for me will be the date.

How can I do this?
Please please help.

Thanks!