Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Splitting rows into rows and columns

I'm looking for advice on how I could split the follwoing rows which display my target and my actuals into columns, essentially reducing on rows and increading my columns. 

This is what I have 

 

This is what I need to achive. 

 

 

Note, I have a number of columns, not just 1, I've just reduced and simplifted to create this example. 



DateColumn4Column 1
01 May 2020Target36
01 May 2020Actual38
01 June 2020Target60
01 June 2020Actual51
01 July 2020Target0
01 July 2020Actual0
01 September 2020Target40
01 September 2020Actual35
01 October 2020Target60
01 October 2020Actual78
01 November 2020Target0
01 November 2020Actual0
01 December 2020Target0
01 December 2020Actual0
  • Anonymous's avatar
    Anonymous
    5 years ago

    Use the "Pivot" operation in Power Query. It's a one-click operation.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Use the "Pivot" operation in Power Query. It's a one-click operation.