Combining data with multiple entities(columns)

calvinwong

Hi!

If I have multiples columns representing different entities, how can i combine them into 1 column while keeping the respective data from other columns?

So the final output will have Account #, Account Name, Book, Tax, Entity number.

Thank you for your help.

Federica_FF

Hi @calvinwong,

you can easily get the result using the transpose and crosstab tools.

In attachment a small example workflow

Combining data with multiple entities.yxmd