Forum Discussion
Move data columns and rows
John, sorry, your data is too bad...
I tried doing few things, following some patterns but it's too complicated to have something that will move everything as you need.
Try selecting more cells of same column and move them where you need. And then another column and so on, until you have everything moved.
Hopefully this is one time job for you. If you will always get data in this format, you will need to fix something at the source of the data.
Cheers.
Ok Thank you for trying, back to moving line by line it is a one off and would not have taken it on if I had realised how long it would take Have already edited down the original data set exported from the old customer database It was 34 col by 3010 rows. What I am working on now is just the members who were issued cards in 2017/8 and their data. Once in single rows per member and correctly headed, I can cut and past by column into the new customer database import format and import into the new sequel customer database that links to the new EPOS software for the client. I have got extra time from my client but must install and go live Monday/Tuesday next week. 145 rows done 558 to go, mark, cut, select, paste, delete, now only 279 times. Thought about putting data into Access or Sequel and writing a SQL but, with the data layout do not see how that would work either. Microsoft Excel Pro Support could not see a solution to automate the job either, that is why I tried the forum as was losing the will to live doing it line by line.
Once again thank you Vitalie for trying.
VitalieCiobanu wrote:John, sorry, your data is too bad...
I tried doing few things, following some patterns but it's too complicated to have something that will move everything as you need.
Try selecting more cells of same column and move them where you need. And then another column and so on, until you have everything moved.
Hopefully this is one time job for you. If you will always get data in this format, you will need to fix something at the source of the data.
Cheers.
VitalieCiobanu wrote:John, sorry, your data is too bad...
I tried doing few things, following some patterns but it's too complicated to have something that will move everything as you need.
Try selecting more cells of same column and move them where you need. And then another column and so on, until you have everything moved.
Hopefully this is one time job for you. If you will always get data in this format, you will need to fix something at the source of the data.
Cheers.
Once again thank you Vitalie for trying.