Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I wish to transpose data in columns B-Z while leaving A intact I have over 1000 equal rows of 26 columns to do this to.

I.E.

A B C D E F G.... 1 2 3 4 5 6 7...

to

A B C D E F G

1 2 3 4 5 6 7

IDEAS? Peter

share|improve this question
1  
Welcome to Stack Overflow! Peter, are you simply looking to show the data in columns 1...7... below the data in columns A...G...? If so, why wouldn't cutting and pasting work? – chuff Jan 31 '13 at 18:54
    
Peter, I get confused about what site I'm on - so welcome to SuperUser!! – chuff Jan 31 '13 at 19:06
    
@chuff and if he wants to swap columns then as you say, why not cut and paste?! looks like a very strange and/or badly written question. – barlop Feb 1 '13 at 0:11

You must log in to answer this question.

Browse other questions tagged .