Results 1 to 8 of 8

Listing dates with corresponding row values in order in columns from oldest to newest

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-25-2019
    Location
    Sioux Falls, South Dakota
    MS-Off Ver
    Microsoft 365
    Posts
    188

    Listing dates with corresponding row values in order in columns from oldest to newest

    Greetings,

    I need to rearrange my data somehow so that they line up in two columns with values from oldest down to newest. The data are dated and each date may have multiple values in corresponding rows. Which is the most efficient way to line up the dates with each value in sequential order down two columns?

    In the sheet example, rows 5 through 8 are dated and each row has several values listed horizontally for each date. How can they be rearranged so that they line up as shown in column W and X?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sorting Dates from Oldest to Newest with the format YYYY-MM-DD
    By jennis7242 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-27-2020, 12:26 PM
  2. Replies: 3
    Last Post: 01-18-2017, 02:02 PM
  3. Unable to sort dates by oldest to newest
    By probuddha in forum Excel General
    Replies: 8
    Last Post: 06-25-2016, 08:27 AM
  4. [SOLVED] Dates seem formatted correctly, but will not sort newest to oldest.
    By MelindaCapri in forum Excel General
    Replies: 6
    Last Post: 02-11-2015, 02:34 PM
  5. How to change this code to sort dates from the oldest to the newest
    By bazofio in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-29-2014, 05:24 PM
  6. [SOLVED] Sort dates in column from oldest to newest...
    By ILoveYouExcel in forum Excel General
    Replies: 2
    Last Post: 06-11-2014, 02:11 PM
  7. [SOLVED] vba to sort columns according to dates in header from oldest to newest.
    By rocksan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-25-2012, 12:57 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1