Columns to Rows using Excel Formula

[pto160]

I would like to convert data from columns to rows. I already got a VBA solution for it. Is there an Excel formula solution? Here is the data.

Book2
	A	B	C	D	E	F	G
1		Jan Sales	Feb Sales	Mar Sales	April Sales	May Sales	June Sales
2	Item A		15				89
3	Item B	100		102	108		456
4	Item c			1000		789
5
6	Expected Results
7	Item A	Feb Sales	15
8	Item A	June Sales	89
9	Item B	Jan Sales	100
10	Item B	Mar Sales	102
11	Item B	April Sales	108
12	Item B	June Sales	456
13	Item c	Mar Sales	1000
14	Item c	May Sales	789
Sheet3

 

[pto160]

Thanks. That works great. It would not be more than a 1,000 rows and 12 columns across. Will it still work?

 

[Peter_SSs]

Will it still work?

Probably as easy for you to check as me.