Transpose rows into columns

[AlterIT]

I have a dataset with few dimensions and I am trying to transpose some of the rows into columns.. Each User ID may have an Acct # in System A or System B or in Both. I need to transpose these Acct #s so that they will be represented as Sys A Acct # and Sys B Acct# . Also wanted 2 Boolean fields which says whether  User ID has entry in Sys A or Sys B.

Tried few options with transpose and cross tab and could not get to work.

[phottovy]

@AlterIT I recommend treating the systems and account numbers as two different calculations. The attached workflow gets the desired result but it could probably use some dynamic column renaming.

[KarolinaRoza · Accepted solution]

Hi @AlterIT 

Please find my solution, it should be fine for your needs.

Regards,

Karolina