Lookups using multiple criteria and results

[Andrew5150]

I need to setup an automated way to put a huge data dump into a useable format, previously I've been using column filters to separate the different positions into tabs and manipulate the date using if statements and manual corrections. Then amalgamating into 1 table.
As you can see not every Account has every Position and some have 2 User name for a Position.
This Data dump is being pulled more regularly, and unable to justify the time it takes to do the manipulation.

So I'm trying to take table 1 and produce table 2, I've tried using lookups and indexing, but get entries where there is no user.

Many Thanks in Advance.

 

[Kerryx]

Would this help

Find match between two sheets

Hey all! For some reason I'm stumped on this one. I'm sure it's something simple, but I've spent way too much time trying to figure it out. I have two sheets of data, and need to see if there is a match between them. Generally an easy ask, but the data is reversed. Example: in the first...

www.mrexcel.com