Transfer Data from One Spreadsheet to Another but other has different layout

Hi Everyone,

I've had a search on the forum but couldn't find anything that seemed to be exactly the same as mine or least didn't appear so. Sorry if it has been asked before.

So, my problem is this:

I created one spreadsheet with thousands of columns of data. Quite a lot of the rows in this original spreadsheet are empty, due to the need to manually find data. We found a way to extract the data much faster, however we do not want to lose the manual data which could not be extracted.



The data in the original has many similar columns, but there are differences, so I cannot simply copy & paste into the second one.

I probably haven't explained this very well, but any help would be extremely appreciated. I can provide more details/pics if necessary. This problem has stumped me for a few days now and it would be great to get it solved.

Thank you.