I have an excel sheet that has 1 column of data in the attached .TXT file. I need that one column split into 6 columns. There are 15,558 lines of data that I need this done for.
I'm hoping there is an excel wizard out there that can create a quick MACRO to make this happen in minutes, instead of the hours that would be necessary for manually cutting and pasting.
Attached is a sample excel file where I have already split the first 5 rows of data up into the 6 columns to show you what needs to be done.
Please be realistic on how long it will take you to finish the job. Don't enter 1 day if you know it will take you 5.
Looking forward to your bid.
8 freelancers are bidding on average $85 for this job
Hi, I can deliver a solution within 24hrs based on the txt file given & will ensure a robust solution for future datasets (including support / modifications for future requirements where appropriate)
There is unknown rule between Owner's Name and Legal Description separations, so this part is hard (impossible?) to do with macro/VBA code. Other parts are OK, but the one I described here.