ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How can I create one column (stacked) from a large table of data.. (https://www.excelbanter.com/excel-worksheet-functions/173485-how-can-i-create-one-column-stacked-large-table-data.html)

Jacko

How can I create one column (stacked) from a large table of data..
 
I have a very large table of data. I need to convert it to so the data is
stacked. Rather than hundreds of columns I need to reduce it to three
columns. One data, and the x and y axis on each row.

[email protected]

How can I create one column (stacked) from a large table ofdata..
 
I think you're stuck with making a macro to do this one.

On Jan 17, 2:38 pm, Jacko wrote:
I have a very large table of data. I need to convert it to so the data is
stacked. Rather than hundreds of columns I need to reduce it to three
columns. One data, and the x and y axis on each row.




All times are GMT +1. The time now is 03:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com