I have a spreadsheet that I get on a regular basis that has a description field that takes up several rows that I need to merge into one field in the parent row for the data.


example:

1.Name.......date.......desc......moredata.....moredata.....somethingelse
2............................desc2..........................................................
3............................desc3..........................................................
4.Name.......date.......desc.......moredata.....moredata.....somethingelse
5.Name.......date.......desc.......moredata.....moredata.....somethingelse
6............................desc2...........................................................
7.Name.......date.......desc.......moredata.....moredata.....somethingelse



I need them to look like this:

1.Name.......date.......desc.desc2.desc3....moredata....moredata....somthingelse
2.Name.......date.......desc......................moredata.....moredata.....somethingelse
3.Name.......date.......desc.desc2.............moredata.....moredata.....somethingelse
4.Name.......date.......desc......................moredata.....moredata.....somethingelse

I have never used VBA in excel before. I have only used it in Access, and not very much beyond some very simple concatenating type functions.

Thanks in advance for any help offered.