Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.