New to Excel: Pivoting alpha data

I am very new to Excel (no experience with macros, etc) and would like to know how to turn Excel Worksheet #1 into Excel Worksheet #2. I don't believe that a pivot table will work because I am not counting or summing anything. Thank you!


Excel Worksheet #1

Number LN FN Term Grade
10652 Jones Ariana Q1 C-
10652 Jones Ariana Q2 B+
10652 Jones Ariana Q3 C-
10652 Jones Ariana Q4 D
10654 Smith Madison Q1 A+
10654 Smith Madison Q2 A+
10654 Smith Madison Q3 A+
10699 White Paola Q1 A
10699 White Paola Q2 A-
10699 White Paola Q3 A-
10699 White Paola Q4 A+


Excel Worksheet #2

Number LN FN Q1 Q2 Q3 Q4
10652 Jones Ariana C- B+ C- D
10654 Smith Madison A+ A+ A+
10699 White Paola A A- A- A+

Hi Susan,

This link can show to do what you need.

https://social.technet.microsoft.com...le?forum=excel

There is a link in that provides an example file that you can modify to your needs.

Hope this is helpful.

Cheers