Hello everyone, I need your help in prepping the data to chart a Sankey Diagram. The Dataset I have currently looks like the following, UserYearBrand A2021AppleA2020AppleB2021SamsungB2020Apple The final table should look a little like this. User20202021AAppleAppleBAppleSamsung Any Idea on how to do this? I know I have to pivot the data but I am lost. Thank you!

Hi, In the Query Editor, go to Transform > Pivot Columns. Here's the screenshot

Anonymous

Not applicable

4 years ago

Solved

Solved: Sankey Diagram Data Preparation

Hello everyone,

I need your help in prepping the data to chart a Sankey Diagram. The Dataset I have currently looks like the following,

The final table should look a little like this.

Any Idea on how to do this? I know I have to pivot the data but I am lost. Thank you!

Ashish_Mathur
4 years ago
Hi,

In the Query Editor, go to Transform > Pivot Columns. Here's the screenshot