Transforming data based on common ID

[Chirag_KRCPL]

Given below is the data (Notice that some of the Ids are repeating) :

I want the output as follows:

ID	Field1	Field2
1	10	-10
2	20	-20
3	30	15
4	40	20
5	50	100
6	60	120
7	5
8	5

So basically I require a new filed that will represent data based on common ID as shown in above snip.

Thanking in advance.

Regards,

Chirag

[Qiu · Accepted solution]

@Chirag_KRCPL 
I was thinking to use the Tile tool but considering the case of same value for same ID, I chose to use the Multirow formula tool.

[flying008 · Accepted solution]

Hi, @Chirag_KRCPL 

If you only want get split , there is have a easy way:

Input			Output
ID	Value		ID	Column_1_Value	Column_2_Value
1	10		1	10	-10
2	20		2	20	-20
3	30		3	30	15
4	40		4	40	20
5	50		5	50	100
6	60		6	60	120
1	-10		7	5
2	-20		8	5
3	15
4	20
5	100
6	120
7	5
8	5

********

If it can help you, please mark it as a solution for share more.

[Chirag_KRCPL · Accepted solution]

@flying008 can you please share this workflow (one with tile & dynamic rename). It would be a great help!

[flying008 · Accepted solution]

Hi, @Chirag_KRCPL 

1-2 Tile + Transpose set in below:

3- Dynamic Rename Expression:

iif(REGEX_Match([_CurrentField_], "^\d+$"),"Field" + [_CurrentField_], [_CurrentField_])