Multiple matching output

Question

Hi,

Can some one help me to get the multiple output with comma seperated.

I have 100o's of GPN Concat where i have multiple matches with in same cell. I need to get the multiple results as bellow(Expected result).

Not sure is there way i can get it. Kindly let me know if there is any solution.

grossal · Accepted Answer

Hi @Ranjan88,

I'd tackle this as follows:

Result:

What happens:

- First we add a RecordID to make sure we get the data back together later on

- We than split the GPN Concat with the | delimiter into ROWS

- I prefer to use a Switch-Case or a Contains for your operation. We can setup Null() as our backup

- We than summarize all rows based grouped by the RecordID. The key here is to use the concatenate function in the Summarize tool.

Settings:

Text-To-Column:

Formula:

Summarize:

I'll also attach the workflow for reference. Let me know if this was helpful and solved your problem.

Best

Alex

Assaf_m · Accepted Answer

Attached is another solution if you are not looking into using the formula and assuming you have a lookup table to join both data.