in MS Excel i want to convert the data entered in a column in to a row. how can i make it. pl help me?

Question

in EXCEL i want to convert the data entered in a column in to a row. how can i make it. pl help me

Answer 1

IT IS VERY EASY



COPY DATA YOU WANT CONVERT

CLICK ON PASTE WILL SHOW OPTION TO CONVERT TO TRANSPOSE

CLICK ON IT.

Answer 2

Copy the data in one or more columns or rows.

Before you paste the copied data, right-click your first destination cell (the first cell of the row or column into which you want to paste your data), and then click Paste Special.

In the Paste Special dialog box, select Transpose, and then click OK.

Answer 3

it can't be finished in Excel. You stand a great gamble in MS observe, besides the fact that it is not likely. decrease the column out of Excel, and paste it into observe. choose the table utilising the "table/choose" function, then use the "table/convert" application to transform the table to text textile with tabs. you could now attempt to chop up off the e-mail addresses via preserving down the alt key whilst you choose the e-mail addresses in straightforward terms. as quickly as they are chosen you could attempt to stick them onto a sparkling Excel web site and that they'd develop right into a table lower back. If not, attempt to re-table-ize them in observe till now bringing them over. i'm assuming the column includes organisation names and e mail addresses of differing lengths and spacing. This inequality of uniformity is what would make it impossible. stable success. good day, I only tried it and it works. the priority stands out as the inequality of uniformity from line to line. as quickly as I did it, I used your occasion line duplicated down a column in Excel. for the reason that each and every cellular became uniform, it labored like a charm. yet with inequal entries, it may not artwork nicely.