Transpose table to Table

Question

Hi Excel Wizards,&nbsp;I got an inventory to be reformated&nbsp;Input:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Product AVariation A1Price A1Variation A2Price A2Variation A3Price A3Product BVariation B1Price B1Variation B2Price B2Variation B3Price B3Product CVariation C1Price C1Variation C2Price C2Variation C3Price C3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Expected:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Product AVariation A1Price A1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Variation A2Price A2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Variation A3Price A3&nbsp;&nbsp;&nbsp;&nbsp;Product BVariation B1Price B1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Variation B2Price B2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Variation B3Price B3&nbsp;&nbsp;&nbsp;&nbsp;Product CVariation C1Price C1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Variation C2Price C2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Variation C3Price C3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Thanks for the Support.&nbsp;RegardsSathy&nbsp;&nbsp;&nbsp;

lorenzo kim · Answer

Mr. Westthat was neat!great info..

lorenzo kim · Answer

pls find attached file - as per your query.the codes may be crude but it worked.hope you can make something out of it.thanks..&nbsp;

philip west · Answer

Mr Kims solution works great, but if you wanted something that doesn't use macros I've attached a worksheet that should do what you want.

Forum Discussion

Transpose table to Table

3 Replies

Resources

Input:

Product A	Variation A1	Price A1	Variation A2	Price A2	Variation A3	Price A3
Product B	Variation B1	Price B1	Variation B2	Price B2	Variation B3	Price B3
Product C	Variation C1	Price C1	Variation C2	Price C2	Variation C3	Price C3

Expected:

Product A	Variation A1	Price A1
	Variation A2	Price A2
	Variation A3	Price A3
Product B	Variation B1	Price B1
	Variation B2	Price B2
	Variation B3	Price B3
Product C	Variation C1	Price C1
	Variation C2	Price C2
	Variation C3	Price C3