how to transpose in excell

  elsanta 12:25 11 Jul 2014

I have 8.1 os. in excell I need to transpose some 50 rows to a column. The fx function only brings up the first entry of the line and ignores the remainder of the array even in a test run of 4 entries. What should I do?

  lotvic 12:53 11 Jul 2014

There is an easy way to convert your rows to columns and vice versa using the Transpose feature in Excel. We’ll show you how.

Select the cells containing the headings and data you want to transpose.

rest of instructions with pictures click here

  elsanta 18:34 11 Jul 2014

Thanks. After much trial and error and searches your method worked straight away. So, why does Microsoft not supply the answers to its software? -- Much appreciated

  lotvic 21:15 11 Jul 2014

Well MS do free tutorials, but it is sometimes harder to find the specific function you want. I learnt mine by going to evening college twice a week for a year. Afraid I've forgotten quite a lot of it now LOL.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

HTC U12 Plus review: Hands-on

Brilliant (and Weird) World Cup 2018 Art and Design Projects

Best Android emulators for Mac

TV & Streaming : comment regarder Roland Garros ?