Stacking 3 columns into 1 with matching cells and headers

UFman2222 - May 29, 2016 at 05:43 PM

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?