How to combine Multiple Record into Single Record

[kevinalvino]

Hi,

I have an issue, please kindly find below:

 :

So in short, 

What need to do to Combine the Record from No 1 and 2, but record in number 2 will be added as new column (Example, NewField) in the first record.

It will be also applied to the occurrence record no 4-6, and so on.

Any input are appreciated.

Thanks,

Kevin

[jdunkerley79]

I would suggest using a MultiRow Formula tool to create a new Index you can then use filters to join to itself.

This makes an index based on first column then joins to itself.

Could you post a sample data file and then can adjust as need?

[kevinalvino]

Sure, I can share some sample to you.

Please kindly find attached.

Thanks,

Kevin

[jdunkerley79 · Accepted solution]

Have attached a sample based off what you sent.

James