sanjayrbajaj
03-13-2009, 08:45 AM
Hi Experts
A client of ours has a variable data job. He has data in mysql data base and can give us the data in an excel list too. The issue is that i need records 2 - 5 to be moved into the columns adjacent to the data of record 1 in row 1. The data in records 6 - 10 should be moved into adjacent columns of record 2 in row 2 and so on.
I am attaching herewith a sample of the format required. In sheet1 we have the original data. I have highlighted 5 rows in different colors. In sheet 2 i have shown how the data should be rearranged. I would like to know if there is a macro or script action which can do this accurately for us. There are over 1 lac records and we do not have the time to do this manually. Moreover there is the possibility of errors in doing this manually
Regards
Sanjay R Bajaj
A client of ours has a variable data job. He has data in mysql data base and can give us the data in an excel list too. The issue is that i need records 2 - 5 to be moved into the columns adjacent to the data of record 1 in row 1. The data in records 6 - 10 should be moved into adjacent columns of record 2 in row 2 and so on.
I am attaching herewith a sample of the format required. In sheet1 we have the original data. I have highlighted 5 rows in different colors. In sheet 2 i have shown how the data should be rearranged. I would like to know if there is a macro or script action which can do this accurately for us. There are over 1 lac records and we do not have the time to do this manually. Moreover there is the possibility of errors in doing this manually
Regards
Sanjay R Bajaj