Good Evening,

I have an issue I have been struggling with. I need to transpose rows of data into rows, in a block format, with the header preceding every row. I guess this would be like taking addresses and phone numbers in a table and putting them into a label format, like Mail Merge in Word. However, it needs to be in Excel. Also not all tables have the same number of columns. This is what I am trying to get to. It gets tedious to do it manually when there are 5 or 6 columns and 40 to 50 rows of data. Thank you in advance.

Scott

Starting table
Name Street City State Zip Phone
Joe Thunderstud 100 Main St Nowhere NM 55555 800-555-1212
Airman Snuffy 2002 B Dorm My Base WA 12345 123-456-7890
Ms. Marple 111 Park Avenue New York NY 12121 121-212-1212

Result
Name: Joe Thunderstud
Street: 100 Main St
City: Nowhere
State: NM
Zip: 55555
Phone: 800-555-1212
Name: Airman Snuffy
Street: 2002 B Dorm
City: My Base
State: WA
Zip: 12345
Phone: 123-456-7890
Name: Ms. Marple
Street: 111 Park Avenue
City: New York
State: NY
Zip: 12121
Phone: 121-212-1212