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 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
Automate repetitive data cleaning tasks using Power Query
A comprehensive course to learn Power Query to automate all your mundane and repetitive data cleaning tasks in Excel or in Power BI
DOWNLOAD THE COURSE OUTLINE | ENROLL IN THE COURSE
