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.
@ajaymanshani Maybe we can use a Multi-Row Formula tool as below.
I was able to solve this using join. Thanks
Hi @ajaymanshani ,
Here you go, this should work for you :-).
Greetings,
Seb
Thanks!
@ajaymanshani another way of doing this with Transpose of and Summarize tool. This should work only the given input
