CrossTab and Repeat

[xuwen901]

Hi there, 

I want to convert the Source chart to Target chart, i tried to use cross tab function, can someone help me with this?

SourceTarget

[Thableaus]

Hi @xuwen901 

You need to use the Transpose Tool instead.

Use Client as a Key Field and the years as Data Fields.

Cheers,

[xuwen901]

Thanks for your reply Thableaus, can you possibly show me an example?

[Kenda · Accepted solution]

Hi @xuwen901 

You will have to rename the fields, but a Transpose tool should actually do the trick! Just use client as the key field.

[Thableaus]

@xuwen901 

Exactly as @Kenda  did.

Cheers,