Consolidate entire sheet data to single column

[Samuel88Joseph]

Hi Team,

I'm having an excel full of email-addresses spread in multiple columns (A - DH), across multiple rows.

I'm looking to consolidate all these cells into a single column (eg, A).

Currently I'm opening a new sheet, taking data from current sheet, each column and pasting at column A of new sheet , similarly repeat the process of taking second row from current sheet and pasting at the the end of last data pasted in column A of new sheet.

Can someone suggest option to do this easily?

Attaching a snapshot for better reference.

Thanks in advance.

Excel - Current Data.png

Excel - Expected outcome.png

[windknife]

=tocol(a:dh,1,true)