+ Reply to Thread
Results 1 to 5 of 5

How to change data from multiple columuns

  1. #1
    Registered User
    Join Date
    04-29-2013
    Location
    Ethiopia
    MS-Off Ver
    Excel 2007
    Posts
    3

    How to change data from multiple columuns

    year Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
    1981 0.265 0.197 0.136 0.176 0.156 0.176 0.265 3.054 2.838 3.109 0.692 0.391
    1981 0.265 0.176 0.156 0.156 0.156 0.136 0.265 3.275 2.892 3 0.692 0.391
    1981 0.265 0.176 0.136 0.136 0.156 0.136 0.265 2.68 3.054 2.733 0.659 0.391
    .
    .
    .
    1981 0.219 0.136 0.265 0.219 0.176 0.505 1.799 3 3.164 0.725 0.419 0.265
    1981 0.197 0.219 0.176 0.176 0.313 2.373 3.22 3.109 0.725 0.419 0.366
    1981 0.197 0.219 0.176 0.176 0.265 2.423 3.109 3.054 0.725 0.419 0.465
    I need these data into the following form:
    1981 0.265
    1981 0.265
    1981 0.265
    1981 0.197
    1981 0.176
    1981 0.176
    1981 .
    1981 .
    1981 .
    1981 0.265
    1981 0.366
    1981 0.465

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: How to change data from multiple columuns

    Copy the data table
    Paste special -> "Transpose"
    Elegant Simplicity............. Not Always

  3. #3
    Registered User
    Join Date
    04-29-2013
    Location
    Ethiopia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: How to change data from multiple columuns

    Thank you for your response, but the command "Transpose" can not work. Here I need the the data from multiple columun with multiple rows into one row/columun with multi columun/rows, respectively.

  4. #4
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: How to change data from multiple columuns

    So you want all data for a single year compiled into a single column ?

  5. #5
    Registered User
    Join Date
    04-29-2013
    Location
    Ethiopia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: How to change data from multiple columuns

    Quote Originally Posted by AndyLitch View Post
    So you want all data for a single year compiled into a single column ?
    Yes, but does't matter it can be in row. What I need is arranging the daily streamflow data given at monthly time steps for each year (from 1980-2010, I need all the daily data for each year at a separate columun or row. I hope you will help me.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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