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 |
Solved! Go to Solution.
@ArunAnnaldas1908
Try the CrossTab tool😁
maybe you can use Tile tool option with "Unique Value" to get it.
Unique Column: [attribute]
Group by : [ID]
***********
Please mark this as the solution if it answers your question, it will help others to find solutions quicker.
Thank You!
This solution worked. Appreciate your quick help!