how to transpose a large data from columns into rows
 

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

how to transpose a large data from columns into rows
 

Look at Text to Columns under the Data menu.

Regards,
Paul


--

"Holly" wrote in message
...
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

how to transpose a large data from columns into rows
 

It only does one column at a time, I need to convert all 12 months at once
quick, because all the input data (month by column) is changes constantly, I
need to convert them quickly in few minutes or less than half hour.

Is there a way to do above quickly?

"PCLIVE" wrote:

Look at Text to Columns under the Data menu.

Regards,
Paul


--

"Holly" wrote in message
...
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