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

Google Home Hub review

Print legends Dan Mumford and Supermundane on making the leap from 2D to AR

How to watch Apple’s October 2018 iPad launch

OnePlus 6T : date de sortie, prix et autres rumeurs