Hi, I need help to fill a column based with data from other cells in the sheet. The problem is that the data is in different columns.
For example, If I have data in following four columns (12 cells), I need that data transposed to a single column.
B1 C1 D1 E1
B2 C2 D2 E2
B3 C3 D3 E3
column A needs to be filled in this order with the data from the following cells;
B1
C1
D1
E1
B2
C2
D2
E2
B3
C3
D3
E3
I need something I can adapt for different tasks, some data tables have 4 columns, some have 10.
I can't copy a normal formula as excel doesn't copy the pattern when I fill down. Some of my data tables have hundreds of rows so I can't do manually.
Any help would be greatly appreciated.
Brian
Bookmarks