Crosstab with missing records

[archanacg1]

Hi,

I am looking for crosstab when the records are missing. In this case version is missing for one of the id. it is supposed to be 3 records only.

Attached is the transformation

[Felipe_Ribeir0 · Accepted solution]

Hi @archanacg1 

One way of doing this

[archanacg1]

Thank you!!