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

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>

 

[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