+ Reply to Thread
Results 1 to 1 of 1

Sorting data from one column to multiple columns by year

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2007

    Sorting data from one column to multiple columns by year

    Hi, thank you for taking the time to read my post.
    I have a worksheet of data with 3 columns:
    A3-date (DD/MM/YYYY),
    A4-flow (a number),
    A5-sym (a letter).

    I have about 50 years of daily data. Some years are 366 days long.
    I need to separate the data into columns so that every pair of columns corresponds to the flow and sym for a certain year. For example, in a new worksheet
    A3-flow 1948
    A4-sym 1948
    A5-flow 1949
    A6-sym 1949
    Some cells are empty and that has to be preserved because data in each cell corresponds to a certain day in the year.
    Does anyone have any suggestions? Any kind of help would be greatly appreciated.
    Last edited by JBeaucaire; 07-30-2012 at 12:20 AM. Reason: Corrected thread title to topic only, as per forum rules

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread


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