Cross Tab

[cowannbell]

I have a table that I'm pulling in and it has only two fields.  Pin and Language.  There can be multiple rows for each pin because they may have multiple languages.

What I need is to transform and have 1 row for each PIN and then columns for their languages.

How can I use the Cross Tab tool to do this because I can't seem to get it to work?

[AngelosPachis]

Hi @cowannbell ,

I have created a new field that acts as a flag, before using a cross-tab tool to bring the table in the format that you would like.

"y" stands for yes, so everything else is no, so that langiage is not contained in that pin group.

Let me know if that worked for you

Cheers,

Angelos

[vizAlter]

Hi @cowannbell  — Try this solution:

Here, I have included an example of duplicates row (PinCodes and Languages), then presented in the sorted output:

[grazitti_sapna · Accepted solution]

Hi @cowannbell , Another way to approach the solution.

If this is what you are looking for kindly mark this post as solution.

Thanks.

[cowannbell]

Thank you all so much.  Sapna's solutions worked best for my needs.