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?
Our take
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]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- How do I keep a placeholder date row sorted on the top of a sheet sorted by descending date?First off, apologies for the poor description in the title. I inherited a lead tracking spreadsheet from someone who was (relative to me) very experienced with Excel. Essentially we have a sheet that sorts by descending dates, so the most recent entry is at the top of the sheet. The way the sheet is configured is that a bunch of cells in the Date Entered column has a placeholder date of 1/1/1900. Nearly all of these sort to the bottom of the sheet, but there was always one of those rows that we had in the top spot to fill out. Once the true date is entered and the sorting is updated that row will go to the correct spot in the list and a new placeholder row with the 1/1/1900 date appears at the top. At some point one of my co-workers did something to the sheet that stopped this from happening, and I do not know what my previous co-worker did to get that function to work because I cannot find anything in the column sort options. Thanks for the help! submitted by /u/Landsharkeisha [link] [comments]
- Need better way to organise spreadsheethttps://preview.redd.it/oiuewnp0pstg1.png?width=599&format=png&auto=webp&s=d34be7eaeb702d5ded087538a2292a57b295dd65 I am currently keeping track of visiting football stadiums (often called the 72 or the 92) as you can see on the attached image, the shear amount of anfield visits leads to many duplicate entries and am wondering if anyone has a suggestion on tidying this up, so that anfield appears once, but perhaps links through so that i can see all visits there will also likely be more stadiums in the future that will have multiple duplicates. *several columns to the right cropped off because of personal data. submitted by /u/EpilepticFlshbng [link] [comments]