Transpose rows into separate columns

You would have faced this problem a ton of times, especially when you copy data from the web. Here is the problem..!

Imagine that you sourced this data and pasted into excel. Unfortunately in this data (Name, Address Line 1 & Line 2 and Phone) are all stacked up, one above the other in rows.

Transpose rows into separate columns 1

Assuming that each record has 4 rows and one empty row in between, how would you bring that in a columnar format? So that it looks something like this..

Transpose rows into separate columns 2

 

DOWNLOAD THE EXCEL FILE HERE

 

Post your answers in the comments

Post your solutions in the comments and if you have a file to share, please paste a link to download the file. I’ll soon update this post with 2 non vba based solutions with you

 



Topics that I write about...






Download Smart Ebooks on
Excel and Power BI