Excel Tricks

1) Multiple Columns' Data to One Column.

Solution:

Open 'Developer' using Options > Ribbon.

Create 'Macro'.

Use the below code inside Macro:

    Range(Selection, Selection.End(xlDown)).Select
    Selection.Copy
    ActiveCell.Offset(0, 1).Range("A1").Select

Open clipboard.

Use Macro Shortcut to perform multiple copy.

Go to position and double click from Clipboard to paste the next columns.

Alternate Solution without Macro:
Use Clipboard, copy all columns individually, choose the position in the column for the values to be pasted, double-click the data to be pasted from the Clipboard. Repeat this until all data is pasted in the same Column.