Is there a way to stack data from multiple columns into one and sort by date?

I am trying to plan when each part of the order is supposed to be made in the columns "XLS".

I have formatted the data below how I want it in the columns Customer to Inoculation Dates.

The data I want to format is from Customer (original) to Quantity 2

I am thinking INDEX and MATCH, but I am completely stumped. I have tried to find the solution online but had no luck

Best,

Mathew

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!