I have a worksheet with 13K+ records, structured similarly to the first underlying table.
I'm trying to figure out how I can get to something that looks like the second underlying table. I was thinking that I could nest some IF statements in with some VLOOKUPs, but my brain isn't working with me today.
I'm trying to figure out how I can get to something that looks like the second underlying table. I was thinking that I could nest some IF statements in with some VLOOKUPs, but my brain isn't working with me today.
Name | Grade | Class | Date | ||
Steve | 10 | B01 | 12/1/2019 | ||
Steve | 10 | B14 | 12/8/2019 | ||
Steve | 10 | D42 | 12/7/2019 | ||
Tom | 12 | B01 | 8/7/2020 | ||
Tom | 12 | B75 | 8/7/2020 | ||
Name | Grade | B01 | B14 | B75 | D42 |
Steve | 10 | 12/1/2019 | 12/8/2019 | 12/7/2019 | |
Tom | 12 | 8/7/2020 | 8/7/2020 |