Merging multiple non adjacent columns into one column

[Excelwig]

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
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[/TR]
[TR]
[TD]Header
[/TD]
[TD]Header
[/TD]
[TD]Header
[/TD]
[TD]Header
[/TD]
[TD]Header
[/TD]
[TD]Header
[/TD]
[TD]Header
[/TD]
[TD]Header
[/TD]
[/TR]
[TR]
[TD]ABC1
[/TD]
[TD]5
[/TD]
[TD]FGH
[/TD]
[TD]2
[/TD]
[TD]OPS
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Abhg
[/TD]
[TD]2
[/TD]
[TD]Has
[/TD]
[TD]5
[/TD]
[TD]SSS
[/TD]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]dsada
[/TD]
[TD]3
[/TD]
[TD][/TD]
[TD][/TD]
[TD]ewew
[/TD]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]sadasd
[/TD]
[TD]5
[/TD]
[TD][/TD]
[TD][/TD]
[TD]weq
[/TD]
[TD]3
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]asdsad
[/TD]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]aawwe
[/TD]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


The result would look like this
[TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl63, width: 64, bgcolor: white"][/TD]
[/TR]
[TR]
[TD="class: xl63, width: 64, bgcolor: white"]Header
[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 64, bgcolor: white"]ABC1
[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 64, bgcolor: white"]Abhg
[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 64, bgcolor: white"]dsada
[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 64, bgcolor: white"]sadasd
[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 64, bgcolor: white"]asdsad
[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 64, bgcolor: white"]aawwe
[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 64, bgcolor: white"]FGH
[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 64, bgcolor: white"]Has
[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 64, bgcolor: white"]OPS
[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 64, bgcolor: white"]SSS
[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 64, bgcolor: white"]ewew
[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 64, bgcolor: white"]weq
[/TD]
[/TR]
</tbody>[/TABLE]

 

[NotoriousPopol]

Hi,

How do we know wich columns you want to "merge"? Do you want to delete these columns after the process?

 

[Excelwig]

Hi,

How do we know wich columns you want to "merge"? Do you want to delete these columns after the process?

Its every other column starting with A so A,C,E etc up until AP

no I don't want them deleting

 

[Excelwig]

After trying various formulas it looks like it might have to be a VBA solution.

not my strongest thing, if anyone can help ?

 

[Excelwig]

Just an addition I would like the cells to be copied to one column to a sheet called Unique and added to the next available blank column if that is possible