Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to transpose a large data from columns into rows | Excel Discussion (Misc queries) | |||
How do you transpose rows to columns? | Excel Discussion (Misc queries) | |||
transpose data between columns, rows or cells | New Users to Excel | |||
How can I transpose rows to columns in a large worksheet? | Excel Discussion (Misc queries) | |||
how do I transpose columns and rows | Excel Discussion (Misc queries) |