Use Multi Row Formula to Find Current Location of Shipment

[andreahq]

Hi,

I'm trying to find the current location of a Shipment. I used the transpose tool to get my data into rows and now I'm trying to use the multirow formula to find the Plant where the shipment currently is. However, I'm not sure if this is the best approach.

Input (after transpose):

Desired Output:

This is what the original source looked before transposing for your reference:

[atcodedog05]

Hi @andreahq 

Here is the workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍