Hello Everyone!
First, let me say that this place is amazing! I posted once before this and the solution I had been seeking for over an hour was solved in 10 minutes. You guys are awesome! So, I'm hoping for a similar outcome here.
The worksheet has unique values (GES101, GES 102, GES103, etc...) in column D. This is my lookup value for a VLOOKUP (Could use Match, Index as well; open to anything). I have multiple rows with these values. For example, I have two rows with a value of GES121 in column A; two rows with a value of GES148, 3 rows of GES152, and so on. The Rows don't go higher than 6 for each unique value, but I have about 500 rows containing unique values going up to GES890.
The values I need are all contained in one column (Column B). So I need a formula that will pull all the values for GES101, GES102, etc...then combine these values into one cell, each separated by a comma.
I hope I explained this adequately. Please feel free to ask questions and please look at the attachment to get a better idea. Thanks!
Bookmarks