### Problem Statement

I have a SharePoint List and I am attempting to take that data, pivot it, and apply style/formatting. I determined that PowerApps would be the ideal solution for achieving this, but am at a loss for how to design/implement this in PowerApps.

### Example Data

| Category | Name | Description |
| --- | --- | --- |
| A | Frank | Lorem |
| A | John | Ipsum |
| B | Sally | Doler |
| C | Lea | Sit |
| C | James | Amet |

### Desired Output in PowerApps

| A | B | C |
| --- | --- | --- |
| Frank | Sally | Lea |
| John |  | James |

Where I have pivoted the Category column into a horizontal row (that expands/contracts according to the data), and the name is able to appear correctly under the respective category (Description field would be in the detail view after clicking on the appropriate name).

The desired output is shown in a table, but that is just the best way to communicate the desired layout structure. I don't know whether this type of structure is best suited for data table, gallery, mix of horizontal/vertical containers, or something else entirely.

What is the best way to perform this data transformation and apply it into a PowerApps layout?