Dear Experts
I am seeking help on a macro which will cut info from a column and paste it under a designated column.
There is a huge table starting from row 2 goes up column CH row 2 is a header (Row 1 is blank). Data is till row 110 (Row numbers and column numbers may vary from file to file). Column A to C have text and data starts from column D and all the way to CH. Help is required to cut all the columns starting from E and paste it column D and do it till the last column.
To identify data it should also insert a column A and paste the header of each row which is cut and pasted in column D
Not too sure if I have explained myself correctly or not hence attaching a sample.
Thanks in advance/VKS
Bookmarks