Forum Discussion

pmadam's avatar
pmadam
Helper II
5 years ago

Dataflow help

I have sql query which has 10 pairs of columns that i need to unpivot and change it to rows, each pair consists of 12 months of data as shown below. I am trying create a dataflow but its not working with multiple pairs and months of data in each pair.

 

 

I want it to be changed as below excel format

 

 

1 Reply