how to transpose in excell

  elsanta 12:25 11 Jul 14
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 14

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 14

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 14

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.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

How VR is being used to simulate space

New iPad, iPhone SE & Red iPhone 7 on sale now