Forum Discussion

Helper III

8 years ago

Solved

Pivot Excel Data

Hi, i wish to pivot my excel data so that it will look like the bottom one. How can i achive this? Thanks!

Community Champion

8 years ago

Hi,

In Query Editor.

1. Select the column with the Budget / Actual

Transform - Unpivot Other Columns

2. Select the column with Budget / Actual

Pivot Column: Value

Regards

Victor

Helper III

8 years ago

Thanks for your help!