I need assistance with a VBA that will take the sample data provided in the link:
https://drive.google.com/open?id=0B4w20SQzW8pCdGZQRFMzUkpnYXc
and pivot all of the date columns to look like the data provided in the link:
https://drive.google.com/open?id=0B4w20SQzW8pCT3R1WENJQV9DeG8
I would like to have the unpivot to be done in a different sheet to prevent the original sheet from being overwritten.
Any assistance is appreciated!
https://drive.google.com/open?id=0B4w20SQzW8pCdGZQRFMzUkpnYXc
and pivot all of the date columns to look like the data provided in the link:
https://drive.google.com/open?id=0B4w20SQzW8pCT3R1WENJQV9DeG8
I would like to have the unpivot to be done in a different sheet to prevent the original sheet from being overwritten.
Any assistance is appreciated!