Coverting data in a one column into a single row

G

Guest

I am pretty sure this is easy question.

I would like to know if there is a quick way to convert data that is in
Column A from cells A1: A26 into Row 1 from cells A1: Z1


That is to convert data in a column into a row.

Thanks in advance
 
G

Guest

i found it..i searched in help. it told me to copy the cells first and then
select the destination cell and do a paste special and check transpose
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Read data from a Row to a Column 5
Excel Help to copy information from one row at a time to another sheet 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Color selected row cells? 4
REPEAT ROW HEADINGS ON EACH PAGE 1
Copy paste data from a column to a row 0
Reformat Row to Column 2
Convert row data into column data 5

Top