1

Folks,

I'm trying to take 2 columns of items; one column has the data I'm looking for in the other column. I want the formula to search the entire column for what I'm trying to match and only pull this data related to each row in the first column. I want this new data to be place in another column separated by commas. For example:

PM-1, PM-11 is in the first column and I want to look thru data in another column and pull out any references to PM-1 and PM-11, see below:

PM-1(a)
PM-1(b)
PM-2(q)
PM-10(e)
PM-11(a)
PM-11(b)
PM-12(a)23[s]
PM-55(e)
PM-34(G)(E)

Then I want the output placed in another cell adjacent to (PM-1, PM-11) to show:

PM-1(a), PM-1(b), PM-11(a), PM-11(b),

I want this done for about 150 rows of data.

Excel example of what I have now

Thanks in advance!!

Tim Green
  • 11
  • 2
  • 1
    Please, read [How much research effort is expected of Stack Overflow users?](https://meta.stackoverflow.com/questions/261592/how-much-research-effort-is-expected-of-stack-overflow-users) and don't forget to read [Why is “Can someone help me?” not an actual question?](https://meta.stackoverflow.com/questions/284236/why-is-can-someone-help-me-not-an-actual-question) . Also check out the [tour](https://stackoverflow.com/tour), and ["help center".](https://stackoverflow.com/help/on-topic) – Foxfire And Burns And Burns Feb 03 '22 at 14:36
  • 1
    Have you tried using the Power Query here, i believe for large datasets, power query works perfectly! – Mayukh Bhattacharya Feb 03 '22 at 14:40

0 Answers0