Column Data to Rows

[yooper29]

Would appreciate any help with this problem. I have an ASCII file that
when imported into Excel, shows the data as follows:

A B C D E
1 A1 B1 C1 D1 E1 ...
2 A2 B2 C2 D2 E2 ...

I need to take, for example, the data in cells D1 and E1 ... and move
it to cells A2 and B2; then move the original data in A2 and B2 to C1
and C2, etc.

Hopefully I've explained this sufficiently. Not sure if this
capability exists. Any help is appreciated.

 

[Bernie Deitrick]

yooper,

You haven't adequately defined you problem (that bit about the etc...)

One approach is to set up your 'rules' using formulas in another block of cells, say, starting in AA1. Once you've figured out what
your rules are, you may find that you can do a lot of copy and pasting of formulas to complete your data block.

HTH,
Bernie
Excel MVP