I have a large data file, it has all monthly sales qty by column, I need to
combine them with another data file, with has all monthly data by row. Both
data files have same columns such as SKU, Price, and Unit of Measurement. Is
there a formula to transpose the monthly data into rows in the first file?

Item Price UOM Jan Feb Mar
A - 1 12.35 Lb 53,500 55,000 50,000
A - 2 7.56 Lb 3,000 4,000 3,500
A - 3 9.2 Lb 19,800 19,800 19,800
A - 4 15.93 Lb 67,485 71,445 79,365

Item Price UOM Period Sales Qty
A - 1 12.35 Lb Jan 48000
A - 2 7.56 Lb Feb 5500
A - 3 9.2 Lb Mar 100000
A - 4 15.93 Lb Jan 50000
A - 4 15.93 Lb Jan 50000
A - 2 8 Lb Feb 6000