Shift section of table data to a new column based on another column value

[ArunAnnaldas1908]

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

[Qiu]

@ArunAnnaldas1908 
Try the CrossTab tool😁

[flying008 · Accepted solution]

Hi, @ArunAnnaldas1908 

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.

[binuacs]

@ArunAnnaldas1908 Another way of doing this with the MultiRow and corss Tab tool

[ArunAnnaldas1908]

Thank You! 

This solution worked. Appreciate your quick help!