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.
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..
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