Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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 

Karlos_1-1606300452027.png

 

This is what I need to achive. 

Karlos_2-1606300476983.png

 

 

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
1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

1 REPLY 1
Anonymous
Not applicable

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors