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 · Accepted solution]

Hi @calvinwong,

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

In attachment a small example workflow

[calvinwong]

Hi @Federica_FF,

Oh wow. That was easy. Thank you so much for your help. I knew there has to be a way but I didn't think of using cross after transpose. That was very helpful. :)