The data I downloaded is in reverse order. I need to flip my columns where the last data cell in the column needs to be the first and the first needs to be the last. How do I do this without individually copying and pastingeach cell.
If no one else comes up with a better way, one better-than-copying-
each-cell sollution is this:
* Highlight all columns with content
* Move all content a few columns to the right (to give you some blank
work space on the left)
* Highlight the last column and move it to column A
* Highlight the new last column and move it to column B
* Repeat as necessary
Oh, I've had another idea.
* Move everything DOWN one row
* In ROW 1, put a sequential identifier (1 in call A1, 2 in cell A2,
and so on)
* Copy and paste everything into a fresh sheet, and "transpose" the
data (columns become rows, and vice versa). Check help for how to do
this: it's easy but I cannot remember off the top of my head and I'm
not at a Mac)
* All your identifiers should now be down the side. Sort on these to
reverse the order
* Copy and "transpose" this new list back into the original
* Delete your identifiers
In Windows (so there's probably something similar in Mac), you can do
Data -> Sort -> Options -> Sort left to right, so you could have a
play with that if it is in Mac (using some column identifiers as
above).
Something useful in there?
PhilD
