Solved: Collection - Transform Rows to Columns

ananda · ‎05-07-2021

Hello

I'm facing an issue on Collection, Transform Rows to Columns.

My Collection looks like

Title	Quarter	Score
XYZ	Q1	80
XYZ	Q2	60
XYZ	Q4	50
ABC	Q1	90
ABC	Q3	76

I'm looking for

Title	Q1	Q2	Q3	Q4
XYZ	80	60		50
ABC	90		76

How to achieve this ?

Thank you for your support.

BR

ananda

RandyHayes · ‎05-07-2021

@ananda

Please consider changing your Formula to the following:

ForAll(
    GroupBy(yourData,
        "Title", 
        "_recs"
    ),
    {Title: Title,
     Q1: LookUp(_recs, Quarter="Q1", Score),
     Q2: LookUp(_recs, Quarter="Q2", Score),
     Q3: LookUp(_recs, Quarter="Q3", Score),
     Q4: LookUp(_recs, Quarter="Q4", Score)
    }
)

This will produce the results that you have asked for.

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes
Really want to show your appreciation? Buy Me A Cup Of Coffee!

View solution in original post

JR-BejeweledOne · ‎05-07-2021

Check this out and see if it helps:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Convert-columns-into-rows-in-Power-apps-Data...

If you like this post, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.

RandyHayes · ‎05-07-2021

@ananda

Please consider changing your Formula to the following:

ForAll(
    GroupBy(yourData,
        "Title", 
        "_recs"
    ),
    {Title: Title,
     Q1: LookUp(_recs, Quarter="Q1", Score),
     Q2: LookUp(_recs, Quarter="Q2", Score),
     Q3: LookUp(_recs, Quarter="Q3", Score),
     Q4: LookUp(_recs, Quarter="Q4", Score)
    }
)

This will produce the results that you have asked for.

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes
Really want to show your appreciation? Buy Me A Cup Of Coffee!

ananda · ‎05-07-2021

WOW, Worked liked charm..

Kudos...

Collection - Transform Rows to Columns

Helpful resources

Join us for Microsoft Power Platform Conference

Power Platform Community Call

Register for a Free Workshop

New Release Planning Portal (Preview)