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.