Hi,
I am trying to transpose a section of data into another column based on values present in attribute column. I couldn't find a similar solution to my problem statement and unable to think of an approach to do it.
Could you please assist here?
Example :
Input
| ID | attribute | Value |
| 1 | OuterAmount | 10 |
| 1 | OuterAmount | 20 |
| 1 | Inner Amount | 30 |
| 1 | Inner Amount | 40 |
| 5 | OuterAmount | 20 |
| 6 | OuterAmount | 100 |
Output
| ID | OuterAmount | InnerAmount |
| 1 | 10 | 30 |
| 1 | 20 | 40 |
| 5 | 20 | |
| 6 | 100 | |
