Summarize a project in one row

I have projects down and companies across. The intersection is how a company segments a give project. A company may segment the same project 1 or more ways.

In the first table, there is more than 1 record for a given project if one or more companies want to segment it.

How can I summarize each project in one row?

Data In...

PROJECT	COMPANY_A	COMPANY_B	COMPANY_C	COMPANY_D	COMPANY_E	COMPANY_F
3041A	Tacos
4567X		Juice		X
4567X		Milk		X
4567X				X
9878C						Cars

Desired Outcome...

PROJECT	COMPANY_A	COMPANY_B	COMPANY_C	COMPANY_D	COMPANY_E	COMPANY_F
3041A	Tacos
4567X		Juice, Milk		X
9878C						Cars

Help

Expression

Accepted answers

hellyars

Here is a solution...

Screen Shot 2021-02-12 at 3.13.29 PM.png

sum_prjct_in_single_row.yxzp

All comments

JagdeeshN

Hi @hellyars ,

I think a summarize tool should do this for you.

Please find attached a sample workflow that showcases the same.

Please do let me know if this helps.

Best,

Jagdeesh Narayanan

sample.yxmd

hellyars

@JagdeeshN I know. That's how I go to this point. This approach forgets to combine Milk with Juice.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703