Crosstab without aggregating

[wonka1234]

Hi,

Is it possible to crosstab without aggregating? 

I have an output like this - but its missing all my other rows.

Concat_Name	Result	Bank	Insured Deposits	Right_Insured Deposits	City	Right_Revenue	Revenue	Right_City	Right_Bank
Bank,City,Insured Deposits,Revenue	Matched	Bank of America	No	No	New York	45Bn	45Bn	New York	Bank of America

expected output - Can this be done?

Concat_Name	Result	Bank	Insured Deposits	Right_Insured Deposits	City	Right_Revenue	Revenue	Right_City	Right_Bank
Bank,City,Insured Deposits,Revenue	Matched	Bank of America	No	No	New York	45Bn	45Bn	New York	Bank of America
Bank,City,Insured Deposits,Revenue	Matched	Citibank	No	No	New York	25Bn	25Bn	New York	Citibank
Bank,City,Insured Deposits,Revenue	Matched	JPMorgan Chase	No	No	New York	50Bn	50Bn	New York	JPMorgan Chase
Bank,City,Insured Deposits,Revenue	Matched	RBC	Yes	Yes	Toronto	49Bn	49Bn	Toronto	RBC
Bank,City,Insured Deposits,Revenue	Matched	Scotiabank	Yes	Yes	Toronto	31Bn	31Bn	Toronto	Scotiabank
Bank,City,Insured Deposits,Revenue	Matched	TD	Yes	Yes	Toronto	48Bn	48Bn	Toronto	TD
Bank,City,Insured Deposits,Revenue	Matched	Wells Fargo	No	No	New York	30Bn	30Bn	New York	Wells Fargo

[binuacs]

@wonka1234 One way of doing this

[wonka1234]

@binuacs  thanks, but some of the data doesnt make sense. Ie a bank has a value for no in the column.

[binuacs · Accepted solution]

@wonka1234 Updated workflow attached