Merging Tables with Different Columns, based on 1 column's data

**dantastical** · 06-18-2019, 02:30 AM

Hi all, I'm a teacher and need to merge some spreadsheets to calculate students' final grades.
Basically what I need is like this, but on a larger scale:
Combine:
Sheet 1:

Email	Score A
email address 1	78
email address 2	47
email address 3	76

Sheet 2:

Email	Score B
email address 1	78
email address 3	74
email address 4	77

To make:
Combined Sheet:

Email	Score A	Score B
email address 1	78	78
email address 2	47	-
email address 3	76	74
email address 4	-	77

How can I combine sheets like this, adding columns from the different sheets but merging identical email addresses into 1 line?
Any help is much appreciated

By the way, I'm using Excel 2007

**Pepe Le Mokko** · 06-18-2019, 02:50 AM

Attach a sample workbook (not a picture or pasted copy). 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.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**AliGW** · 06-18-2019, 02:50 AM

Welcome to the forum!

Please update your user profile with the correct version of Excel. Thanks.

**dantastical** · 06-18-2019, 03:08 AM

Hopefully I've attached a spreadsheet to show what I mean. Sheet 1 and 2 are the inputs, and sheet 3 is what I want as the output.
Any help is much appreciated