I have an excel sheet that has 1 column of data. I need that one column split into 6 columns. There are 1325 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 the excel file. I have already split the first 7 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.