Dear Friends,
I have a worksheet with 10000 records. For example, entire data in ColA-ColZ.
In that, ColA-ColF - Personal Information; ColG-J Group1; ColK-N Group2; ColO-R Group3; ColS-U Group4; ColW-Z Group5.
I this case, the data to be copied into another sheet as follows:
1) the personal data should be copied repeatedly.
2) Each Group data should be copied next to personal data.
3) The group's name is mentioned at the top of the datasheet.
I have attached a sample workbook for your kind reference.
I hope someone will help me to solve this.
Thanks a lot in advance,
acsishere.
Bookmarks