Share via

Sorting multiple columns chronologically with blanks into one new table.

Anonymous
2024-08-19T13:36:26+00:00

I am trying to sort a separate sheet by year to get a chronological list to keep track of based on the Date, but need to also include additional information in the row. See screenshot attached. Top is what it currently is, bottom is what I'm trying to get. If I can also have it automatically link to the previous sheet so I don't have to copy and paste the "raw" data, that would be very helpful as well.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2024-08-19T14:03:28+00:00

    Load the data into Power Query and unpivot the Practice columns. https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098

    If you need further help I need to see your (sample) file.
    Why a sample file is important for troubleshooting. How to do it. - Microsoft Community

    Andreas.

    Was this answer helpful?

    0 comments