Quote Originally Posted by Glenn Kennedy View Post
If you want them all in one cell you will need one of the following:

1. VBA ( a UDF).. saved as .xlsm

2. Helper column.

3. Upgrade to O365.

If you're Ok with them in separate columns:

=IFERROR(INDEX($I:$I,AGGREGATE(15,6,ROW($A$2:$A$40)/($A$2:$A$40=$A2),COLUMNS($K$2:K2)))&"","")

copied across and down. Adjust the range (the bits in red) as needed. Don't go mad and use whole column references there, unless you do have 1,000,000 rows.
Glen, I really appreciate your help! I was able to use the formula you provided to pull the data into separate columns. I can run a =CONCAT if I choose to pull them together.
Our Warehouse guys are doing inventory checks on select items and I wanted to pull all possible locations for each SKU.

Thanks again!! :D

Keith R.