how to transpose in excell

  elsanta 12:25 11 Jul 2014
Locked

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. office.microsoft.com/en-gb/support/ 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

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?