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

[dantastic]

Hi all, I'm a teacher and need to merge rows of a spreadsheet to calculate students' final grades.
Basically what I need is like this, but on a larger scale:
Change this:

a________1
a________1________2
a________1________1________3
b________1________6
c________7
c________1________8
c________1________1________4

Into this:

a________1________2________3
b________-________6________-
c________7________8________4
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:)

[RusselB]

Welcome to the Forums.
I'm going to suggest looking at using a Pivot Table (aka Data Pilot).

[MrProgrammer]

Change this:
   a   1
   a       2
   a           3
   b       6
   c   7
   c       8
   c           4

Into this:
   a   1   2   3
   b   -   6   -
   c   7   8   4

Open attachment. Review formulas in G1:K8. In cell K1, click dropdown and select 1. Or click cell K2 then use Data → Filter → Standard Filter → Field name → Last? → Condition → = → Value → 1 → More Options → Copy results to → «somewhere» → OK. Note that style NoZero has been applied to H2:J8.

201906211708.ods

(11.18 KiB) Downloaded 122 times

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.