Stacking 3 columns into 1 with matching cells and headers [Closed]

Report
-
Hello,

I have a table with data dating back weekly for 7 years. I am shifting it over to a new system but need to import the data in another format than what I have it in and I'd like to avoid having to manually retype 7 years worth of data.

What I have:
Hd1 Hd2 Hd3
Date 1 B1 C1 D1
Date 2 B2 C2 D2

What I need:
Date 1 Hd1 B1
Date 1 Hd2 C1
Date 1 Hd3 D1
Date 2 Hd1 B2
Date 2 Hd2 C2
Date 2 Hd3 D2

Any ideas?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!