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:
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
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
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1