1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: 2003 Excel - Invert Column Listings

Discussion in 'Business Applications' started by exceller, Feb 8, 2015.

Thread Status:
Not open for further replies.
  1. exceller

    exceller Thread Starter

    Joined:
    Dec 2, 2003
    Messages:
    408
    I have a spreadsheet using Excel 2003 recently created.

    There are some 10 columns with numbers in each cell, starting from February 2015 in line No.14 down to line 1000 with a date January 2007..

    What I want to do is to invert all the data, so Jan 2007 is at the top of the listing and Feb 2015 is at the bottom, (basically turning it all upside down).

    Reason for this, is when I add new data it can be added to the existing listing at the bottom without effecting the current listing.

    If I copy and paste new data to the top of the current listing, this overwrites the existing listing.

    thanks
     
  2. cwwozniak

    cwwozniak Trusted Advisor Spam Fighter

    Joined:
    Nov 28, 2005
    Messages:
    64,185
    First Name:
    Chuck
    Would a simple sort by date in ascending order work?
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1142712

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice