I am trying to pull data out of a database dump that looks like this

76076 SWLZ SEC1 EA 4
76076 SWLZ SEC2 EA 4
76076 SWLZ SEC3 EA 4
76076 SWLZ SEC4 EA 4
76076 SWLZ SEC5 EA 4
76156 SWLZ SEC1 EA 1
76156 SWLZ SEC2 EA 1
76156 SWLZ SEC3 EA 1
76156 SWLZ SEC4 EA 1
76156 SWLZ SEC5 EA 1
76165 SWLZ SEC1 EA 1
76165 SWLZ SEC2 EA 1
76165 SWLZ SEC3 EA 1
76165 SWLZ SEC4 EA 1
76165 SWLZ SEC5 EA 1
76231 SWLZ SEC1 EA 6
76231 SWLZ SEC2 EA 6
76231 SWLZ SEC3 EA 6
76231 SWLZ SEC4 EA 6
76231 SWLZ SEC5 EA 6
76232 SWLZ SEC1 EA 6
76232 SWLZ SEC2 EA 6
76232 SWLZ SEC3 EA 6
76232 SWLZ SEC4 EA 6
76232 SWLZ SEC5 EA 6
76233 SWLZ SEC1 EA 1
76233 SWLZ SEC2 EA 1
76233 SWLZ SEC3 EA 1
76233 SWLZ SEC4 EA 1
76233 SWLZ SEC5 EA 1
76431 SWLZ SEC1 EA 1
76431 SWLZ SEC2 EA 1
76431 SWLZ SEC3 EA 1
76431 SWLZ SEC4 EA 1
76431 SWLZ SEC5 EA 1
76432 SWLZ SEC1 EA 5
76432 SWLZ SEC2 EA 5
76432 SWLZ SEC3 EA 5
76432 SWLZ SEC4 EA 5
76432 SWLZ SEC5 EA 5
76433 SWLZ SEC1 EA 5
76433 SWLZ SEC2 EA 5
76433 SWLZ SEC3 EA 5
76433 SWLZ SEC4 EA 5
76433 SWLZ SEC5 EA 5
76434 SWLZ SEC1 EA 2
76434 SWLZ SEC2 EA 2
76434 SWLZ SEC3 EA 2
76434 SWLZ SEC4 EA 2
76434 SWLZ SEC5 EA 2
76435 SWLZ SEC1 EA 2
76435 SWLZ SEC2 EA 2

There are 5 locations SEC1-SEC5 that all carry the same sku just in a
different physical location. I would like to create 5 colums that looks like
this

76076 SEC1 4
76156 SEC1 1
76165 SEC1 1
76231 SEC1 6
76232 SEC1 6
76233 SEC1 1
76431 SEC1 1
76432 SEC1 5
76433 SEC1 5

I dont think I can explain it fully, I would love to email someone the
workbook and let them see what I am trying to work with. It will be a very
dumbed down workbook, not the original. I will show you the combination of
IF-AND-VLOOKUP that worked but will only pull the 1st occurrence of the
number. Please let me know if anybody can help. I have never been this
stumped over something I can not figure out in Excel. Thanks.

-Charlie