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




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!