Results 1 to 5 of 5

Thread: Excel Data set shift?

  1. #1
    DR
    DR is online now
    on ye old ship HEXUS DR's Avatar
    Join Date
    Jul 2003
    Location
    HEXUS HQ, Elstree
    Posts
    13,411
    Thanks
    1,058
    Thanked
    831 times in 372 posts

    Excel Data set shift?

    Guys,


    I have an Excel sheet with a load of data in it - 2005 is at the bottom and the latest is at the top.

    I want to shift it so all of the data is the other way around so it lists oldest first - its multiple columns.

    Any ideas?

  2. #2
    Funking Prink! Raz316's Avatar
    Join Date
    Jul 2003
    Location
    Deal, Kent, UK
    Posts
    2,978
    Thanks
    130
    Thanked
    62 times in 52 posts

    Re: Excel Data set shift?

    how many rows, how many columns?

  3. #3
    Does he need a reason? Funkstar's Avatar
    Join Date
    Aug 2005
    Location
    Aberdeen
    Posts
    19,874
    Thanks
    630
    Thanked
    965 times in 816 posts
    • Funkstar's system
      • Motherboard:
      • Gigabyte EG45M-DS2H
      • CPU:
      • Intel Core2Quad Q9550 (2.83GHz)
      • Memory:
      • 8GB OCZ PC2-6400C5 800MHz Quad Channel
      • Storage:
      • 650GB Western Digital Caviar Blue
      • Graphics card(s):
      • 512MB ATI Radeon HD4550
      • PSU:
      • Antec 350W 80+ Efficient PSU
      • Case:
      • Antec NSK1480 Slim Mini Desktop Case
      • Operating System:
      • Vista Ultimate 64bit
      • Monitor(s):
      • Dell 2407 + 2408 monitors
      • Internet:
      • Zen 8mb

    Re: Excel Data set shift?

    Is there a date column?

    Just have one cell in that column selected, and hit Z->A or A->Z as oppropriate and all colums should sort. If you select more than one cell, it will only sort the selection.

  4. #4
    Does he need a reason? Funkstar's Avatar
    Join Date
    Aug 2005
    Location
    Aberdeen
    Posts
    19,874
    Thanks
    630
    Thanked
    965 times in 816 posts
    • Funkstar's system
      • Motherboard:
      • Gigabyte EG45M-DS2H
      • CPU:
      • Intel Core2Quad Q9550 (2.83GHz)
      • Memory:
      • 8GB OCZ PC2-6400C5 800MHz Quad Channel
      • Storage:
      • 650GB Western Digital Caviar Blue
      • Graphics card(s):
      • 512MB ATI Radeon HD4550
      • PSU:
      • Antec 350W 80+ Efficient PSU
      • Case:
      • Antec NSK1480 Slim Mini Desktop Case
      • Operating System:
      • Vista Ultimate 64bit
      • Monitor(s):
      • Dell 2407 + 2408 monitors
      • Internet:
      • Zen 8mb

    Re: Excel Data set shift?

    And if you don't have a column you can easily sort on then add one.

    Insert a column, put '1' in the first row and '2' in the second. Now select them. Grab hold of the black square on the bottom right hand corner of the selection and pull it down to the bottom of your data, Excel will incriment the values for you. Now you can reverse sort your list and remove the column once it is done.

  5. #5
    Seething Cauldron of Hatred TheAnimus's Avatar
    Join Date
    Aug 2005
    Posts
    17,164
    Thanks
    803
    Thanked
    2,152 times in 1,408 posts

    Re: Excel Data set shift?

    indeed this sounds like a job for the 'sort' feature!
    throw new ArgumentException (String, String, Exception)

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Mr Brown Saving us 'Again'?
    By TheAnimus in forum Question Time
    Replies: 21
    Last Post: 29-05-2008, 03:28 PM
  2. Business Server - Data Backup Methods
    By cptwhite_uk in forum Networking and Broadband
    Replies: 12
    Last Post: 27-02-2008, 12:25 AM
  3. Raid guide for beginners post edition
    By alsenior in forum PC Hardware and Components
    Replies: 2
    Last Post: 09-09-2007, 10:40 PM
  4. Netscreen 5-GT configuring resilience
    By jez_convergence in forum Networking and Broadband
    Replies: 4
    Last Post: 23-08-2007, 02:31 PM

Posting Permissions

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