Collection - Transform Rows to Columns

[ananda]

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

[JR-BejeweledOne]

Check this out and see if it helps:

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

[RandyHayes · Accepted solution]

@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.

[ananda]

WOW, Worked liked charm..

Kudos...