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.

Welcome to the forum. Unfortunately, a picture is impossible to work with.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data. (Remove private or sensitive data that shouldn't be published)

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Click on Browse under Upload Files from your Computer and then find the file on your computer using the dialogue that opens. Click on Open then click on Upload. Click on Close this Window. Click on Submit.

Couldn't you just copy the data from one worksheet and paste under the data on the other worksheet (or copy both to another worksheet) then select all the data, click on the Data tab, Remove Duplicates? Your workbook shows identical setup of both sets of data which appears to be different from your picture. Which one is correct the picture or the workbook?

Using your sample, I created two worksheets that will copy the data from each of the other worksheets. Sheet1 will copy the data if the layout is in the same order. Sheet2 will copy the data relying on the column headers to get the data in order if it is different on the other worksheets. A helper column for Sheet2 was created on worksheets Practice 1 and Practice 2 which are used in worksheet Sheet2.

There are also calculations in columns R and S of Practice 1 and Practice 2 to calculate the number of rows necessary in the combined worksheets.

I've explained this badly. Will attach another sample to try and better explain as the workbooks exceed the allowance.