If you like this post please share it!
I do data cleaning day in day out. We all do. This technique from Leila Gharani on You Tube is just so awesomely simple and effective you just wonder why you haven’t thought of this before. It works on the principle that Excel likes to be helpful and anticipate your needs so if you show it the messy pattern you need for row numbers from just 2 rows of text and copy down, it will follow that pattern and pull this messy data together. Leila has a lot of great videos of course but I just laughed when seeing this one and wondered how many times in my career I could have used this one. Thank you Leila!