Forum Discussion
Move data columns and rows
See attached file, is this what you need? Please note that your data is not following same pattern.
Should it always alternate one row with "Points/N" and then next row with "2017/8 card number"? Currently it does not, so moving all "2017/8 card number" values may not get as accurate as you need.
I don't understand what you want here: "Alternatively move all data in row starting with 56099* to end of previous row, deleting row with 56099*"
Ok Not quite what I need to do.
However if I forget about just moving the card number and move all the data in the row containg the card number to the end of the previous line That works, However doing it line by is a total pain so wondered if ther is a quicker wat IE a formula that will do this Even if it moves the data and leave the blank lines that can then be deleted as seperate job that will save me hours. Will attach a section of the spread sheet showing original data with rows hidden to make it easier and the end rssult of the move.
I am selecting the boxes needed to be moved xopy selecy where they need to be and paste then remove the empty lin still 300+ lines to sort Any help appreciated
John M Cowan wrote:Ok Not quite what I need to do.
However if I forget about just moving the card number and move all the data in the row containg the card number to the end of the previous line That works, However doing it line by is a total pain so wondered if ther is a quicker wat IE a formula that will do this Even if it moves the data and leave the blank lines that can then be deleted as seperate job that will save me hours. Will attach a section of the spread sheet showing original data with rows hidden to make it easier and the end rssult of the move.
I am selecting the boxes needed to be moved xopy selecy where they need to be and paste then remove the empty lin still 300+ lines to sort Any help appreciated
sample data added
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.