Pulling multiple rows of data in column from source sheet to a target sheet


I would like to pull multiple rows of data from a single column and populate it in a column in a target sheet while filtering.

For example I have an auto updating sheet fed by API that auto-deletes and refreshes every 15 mins (No helper columns allowed).

I'm wondering if it is possible to pull Trailer number by load status/customer?

API source sheet

Target sheet

@Paul Newcome


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!