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
Bookmarks