Hello,
I have a data set that contains market name, brand name, package size and a few related metrics. It is a sequential file in ascending market sequence. See sample and attached, Sheet1.
What I would like to do is move each market after Atlanta to the right of the Atlanta metrics. See sample and attached, Sheet2
I've tried to pivot the table but have been unsuccessful. Any suggestions would be appreciated.
Thanks!
Solved! Go to Solution.
Derek, this is awesome. Thanks for your help. Much appreciated!