Hi
Can someone help with this, I have a worksheet with 62 columns of data, I want to take every other columns data and make one column
eg Column A,C,E,G until AP
each column has different amount cells of data so I want it so it doesn't leave a blank space when merged to one column say column AS
The columns have headers so I want it to start from row 3
example in the below I would want the data from column A,C,E,G starting in row 3 merging into one column with no spaces
<tbody>
</tbody>
The result would look like this
<tbody>
</tbody>
Can someone help with this, I have a worksheet with 62 columns of data, I want to take every other columns data and make one column
eg Column A,C,E,G until AP
each column has different amount cells of data so I want it so it doesn't leave a blank space when merged to one column say column AS
The columns have headers so I want it to start from row 3
example in the below I would want the data from column A,C,E,G starting in row 3 merging into one column with no spaces
A | B | C | D | E | F | G | H |
Header | Header | Header | Header | Header | Header | Header | Header |
ABC1 | 5 | FGH | 2 | OPS | 1 | ||
Abhg | 2 | Has | 5 | SSS | 2 | ||
dsada | 3 | ewew | 2 | ||||
sadasd | 5 | weq | 3 | ||||
asdsad | 2 | ||||||
aawwe | 2 | ||||||
<tbody>
</tbody>
The result would look like this
Header |
ABC1 |
Abhg |
dsada |
sadasd |
asdsad |
aawwe |
FGH |
Has |
OPS |
SSS |
ewew |
weq |
<tbody>
</tbody>
Last edited: