Hi, I need a way to clean up my data so that after it is done, I can use a pivot table to make sense of my data. I have something like this
ExcelExample1.png
,and I would like to convert it into
ExcelExample2.png
I have like 50000 rows of such messy data, and I do not want go through the data one by one to copy and paste.
Therefore I am hoping if there is way of using VBA for this, any ideas is appreciated.
Thank you.
ATTACHED is an example file
Last edited by coltan123; 09-02-2020 at 12:27 AM.
According to your file, the data starts in cell B9.
Results in J9.
Try this:
Please Login or Register to view this content.
Visit : Excel & Macro
https://www.youtube.com/@CursosDeExcelyMacros
Work Perfectly. Thank you so much
Just some questions, if I would like to add additional column , how do i go about in doing it and how do I put the data in another sheet. Much appreciated.
Try this:
Change "F" in a = Range("B9:F" for the last column
Please Login or Register to view this content.
Hi,
Sorry to keep troubling you, but the code is not working, it show a type mismatch error which, unfortunately, I am unable to troubleshoot. Hope you may help me out if you are free. Thank you.
Try this:
Please Login or Register to view this content.
Awesome, it is working well. Thank you so much.
I'm glad to help you. Thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks