Hello,

I receive spreadsheets from a client that I need to extract a list from
Here is what the spread sheet looks like when I get it:

DD1 DD2 Q3 K1 K2
501 1
502 1
503 1
504 1
505 1
506 1
507 1

What I want to have at the end is this:

501 DD2
502 K1
503 DD1
504 K1
505 K2
506 Q3
507 DD1

If you can help me with a formula I'll be able to save tons of time.

Thanks,

Kirk