1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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!

submitted by /u/mtgoni
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#rows.com
#big data management in spreadsheets
#conversational data analysis
#Excel compatibility
#large dataset processing
#row zero
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#Excel alternatives
#data analysis tools
#data cleaning solutions
#natural language processing for spreadsheets
#farming
#activity schedules
#plot of land