Need help for Formula

Question

Hi,

I have data like shown in below.

Input IDName111America111America111America111West Virginia111West Virginia222South America222Portland222Florida222Florida333Newyork333Newyork333California333Nevada333Nevada444Chicago444Chicago444Chicago444Ohio444Ohio

I am expecting my output like below.

From and to: From where it is starting and where it is going.

Final destinations: This is always last name for each id.

Output   IDFromToFinal Destination111AmericaWest VirginiaWest Virginia111   111   111   111   222South AmericaPortlandFlorida222PortlandFlorida 222   222   333NewyorkCaliforniaNevada333CaliforniaNevada 333   333   333   444ChicagoOhioOhio444   444   444   444

philipmannering · Accepted Answer

Hi Pinky,

Looks like you might have taken a wrong turn there @rafalolbert

Here's another solution.

Workflow

Thanks,

Brain (Philip)