Is there a way for me to sort dates found across multiple columns into another set of columns and have the original column headers next to each sorted dates?
I have a sheet that details my farming activity schedules. Each row represents individual plot of land (LandID#), while columns represents each farming activities (eg. seeding, thinning, pot-up, transplant, and removal). As I input the seeding date, all the other activity dates are populated.
As I am growing many different types of crops, the quantity of varying dates is large. Using this sheet alone, makes it very difficult and tiring just to figure out what activity is next on schedule.
I'm hoping that there is a way to present these dates in a manner that is more intuitive. Perhaps presenting these into 3 columns: Date, Activity, and LandID#. Then having the data sorted ascendingly by date. Or perhaps there is a better idea.
Thanks in advance!
[link] [comments]
Want to read more?
Check out the full article on the original site