How to do it
Well that is not the only thing it does. Its powers go beyond just splitting data in different coloumns. It can literally convert text to numbers in coloumn as well. But well that is left for future tutorial
The application of this feature is however limited to delimiter or width etc. So you have to take care in this regard.
Paste Special Transpose from coloumn to row
Surely up to its name because Paste Special is regular Paste’s big brother on steroids and has numerous tricks up his sleeves worth noticing.