Transposing multiple rows into one row

[Rodez]

I'm trying to create an excel file that I can use in order to complete a mail merge into a word document.

This is the information that I currently have is separate per employee and family member. The empty row separates each family.

I need to know what formula/function I can use in order to transpose all the family's information into 1 row so I can do a mail merge. The empty row would be used to tell excel to skip to the next family.

Attached is a sample of what I have and need to do. Unfortunately I'm working with large data and it just unfeasible to do them one by one. (It didn't let me attach the actual excel file).
Capture.JPG

Any help will be appreciated.
Thanks!

[JBeaucaire]

Give this a try. It assumes the headers are in row1 and the data starts in row2.

Please Login or Register  to view this content.

How/Where to install the macro:

1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save as a macro-enabled workbook

The macro is installed and ready to use. Press Alt-F8 and select it from the macro list.

[Rodez]

Awesome, thank you soooo much!