How to put the Multiple Value in one cell from multiple cell

[Shermaine2010]

There are 2 sheet - Data Source and Ideal output.

How to put the Multiple Value in one cell from multiple cell

Please help

Thanks

[Bo_Ry]

For MS 365
=TEXTJOIN(" | ",,REPT(Table4[Group],Table4[Action]=D$1))

but for other vesion, helper column is needed.
Data source F2
=E2&IFNA(" | "&VLOOKUP(D2,D3:F12,3,0),"")

Ideal D4:F4
=VLOOKUP(D$1,Table4[[Action]:[Helper]],3,0)

[Shermaine2010]

Data source F2
=E2&IFNA(" | "&VLOOKUP(D2,D3:F12,3,0),"")

That bold always is one row lower. How to add in if want to put the data source as table?
The data source may add in new information day to day, if using the above formula, need to keep adjust.
Thanks

[Bo_Ry]

Try

=E2&IFNA(" | "&VLOOKUP(D2,D3:INDEX([Helper],ROWS(Table4)),3,0),"")

[Shermaine2010]

How about the Helper For mutilple criteria lookup?

[Bo_Ry]

Try at G2

=IF(ROWS(G$2:G2)=ROWS(Table4),E2,E2&IFNA(" | "&INDEX(G3:INDEX([Helper1],ROWS(Table4)),MATCH(1,INDEX((A3:INDEX([Module],ROWS(Table4))=A2)*(B3:INDEX([Category],ROWS(Table4))=B2)*(C3:INDEX([Process],ROWS(Table4))=C2)*(D3:INDEX([Action],ROWS(Table4))=D2),),)),""))