MATCH FROM & TO and then insert data from 2nd row to first row as a new column

[ajaymanshani]

In the Input I have From and To, so I basically need to match from and To pairs and then if matched then insert both the times in one row itself as a new column.

[Qiu]

@ajaymanshani 
Maybe we can use a Multi-Row Formula tool as below.

[ajaymanshani]

I was able to solve this using join. Thanks

[Sebastiaandb]

Hi @ajaymanshani ,

Here you go, this should work for you :-).

Greetings,

Seb

[ajaymanshani]

Thanks!

[binuacs]

@ajaymanshani another way of doing this with Transpose of and Summarize tool. This should work only the given input