Results 1 to 4 of 4

Convert Single column data into multiple columns

Threaded View

  1. #1
    Registered User
    Join Date
    06-24-2013
    Location
    Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    30

    Convert Single column data into multiple columns

    Hello Every body,

    I am working on large dataset of flows and having daily values of year in single column. e.g 365 values of year 2001 in Column A, 365 values of year 2002 in Coulmn B and so on. I need to sort out data into 12 rows each representing one month starting from January to December having daily values in months. Could any body help me in this regard. A sample data sheet is attached.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 08-26-2015, 02:02 PM
  2. [SOLVED] Convert column B as multiple column titles and move data in column C into new columns?
    By princesscathryn in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 06-30-2014, 07:31 PM
  3. Replies: 6
    Last Post: 12-06-2012, 11:05 AM
  4. Replies: 1
    Last Post: 07-04-2012, 06:25 AM
  5. [SOLVED] How to automate, convert single column of data into two columns of data?
    By Dale Saukerson in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-07-2012, 09:53 PM
  6. [SOLVED] Convert data in multiple columns to single column
    By rkoffy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-07-2012, 08:03 AM
  7. convert single column to multiple columns
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 12-07-2007, 12:40 PM

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