Transposing Help Please

[MrClarkes]

Hi MrExcel and friends,

I need help with the following.

I have a table that is set up like this

Jan Feb March April May June
Stuff1 10 5 5 6 7 2
Stuff2 20 4 5 7 8 9
Stuff3 3 4 4 4 4 1
Stuff4 1 2 4 5 3 3

I need to write a formula that will take the above and turn it from a cross table to a list so it reads

Stuff1 Jan 10
Stuff1 Feb 5
Stuff1 Mar 5
.
.
.
.
.
Stuff2 Jan 20
Stuff2 Feb 4
.
.
.
.
.
And so on.

Is this possible?

Please help.

Thanks,

C

 

[GTO]

Try posting your data with one of these methods:

To post sample data:
Excel Jeanie
Or
TO CONTACT RICHARD
Richard Schollar's HTML Maker
OR TO DOWNLOAD EITHER HTMLMaker (Richard's table maker) or VBHTMLMAKER (code) IN OLDER BROWSER
https://skydrive.live.com/?cid=8cffdec0ce27e813&sc=documents&id=8CFFDEC0CE27E813!189&brby=1

Or
Borders;Copy;Paste