macro- copying a row of data to seperate columns

I need a macro to copy 2nd row of data to alternate columns. When i tried with macros by recording the operation, it does not work. Also, with VBA code, it works only for one cell value

Suppose my data is as below:

1452500002000 S CHANDRAS 1075 2015
BCF-789 2/174, ZION STREET 38 154

My output should be as below:

1452500002000 BCF-789 S CHANDRAMOHAN 2/174, ZION STREET 1075 38 2015 154

Like wise , I need data of 25000 lines to repeat.
By: Iswariya

Leave a Reply

Your email address will not be published. Required fields are marked *