VBA code to transpose a set of values in rows to columns in Excel 2010

I have an excel data set that looks something like this:

Name Number Address
ABC 123 ABC St
123
New York, NY 11234


I wanted to transpose the row data to columns like this:

Name Number Address Address2 Address3 City St Zip Code
ABC 123 ABC St 123 New York NY 11234

This is only my sample date. But I have more than 5000 rows. I have attached the sample date within this . Please feel free to ask if you have any questions. I checked in many forums but was not able to find any solution. I am looking for a macro.

Thanks for looking into my matter.

Please Login or Register  to view this content.