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.