Hello Everyone
Before I make any changes I want to make sure my thinking is correct. I have looked at various functions on the handout that Mynda shares. It is really helpful.
I will attach a work book which is the old system and is the one populated. I have now been given a new template to order the data in that manner. The template has more columns and those are in a different order to the old system.
I think my best way to transfer the data is to copy and paste column by column to the right place on the new template. As all the rows are populated (ie mostly no blanks), I should be able to past say 50 rows for each column either one by one or several ones together if in the right order.
alternatively I could also then simply move the columns in the original template to fit the right column order according to the new template.
Many thanks for your advice.
Susan
The screenshots that you attached are rather small and difficult to read. Could you instead upload the xlsx files (old and new). Just make sure you remove any confidential information from them and replace it with made-up names etc.
Here are the excel workbooks, nothing is confidential, old historical records
Thanks for the files. Any particular reason why there is one entry separated from the other records in the GMI file (row 166 that is)?
If this is all the data you have to deal with a one time manual process could work. Map the old column headers to the new ones first. Insert a row at the top and type the column letter where they should go in the new file. Drag them into the correct place. Shouldn't take all that much time. Then copy all rows in one go and paste them into the new file.
Alternatively, and if you need to clean up the old data first, you could consider to use Power Query to do the cleaning and putting the columns in the correct order. You would still need to map the old headers to the new and reorder the columns.
Thank you Riny. That's helpful. Organising it first is a good idea! Will do that.
Will check row 166 as well!
This is brilliant
Susan
