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.


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



1 2 3 4 5 6 7

IDEAS? Peter

share|improve this question
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 .