simple question

[alhurayas]

hi all I have simple question

in sheet1 I have all my data
and sheet 2 to have the same date but the ROWS should be converted to COLUMNS

thanks you very much for any the help

 

[JoeMo]

Take a look at the TRANSPOSE worksheet function in Excel Help.

 

[alhurayas]

mr joeMo
thank for replying could not find the same thing I am looking for please help

 

[alhurayas]

any help please

 

[Stiuart_W]

Select the data in sheet. Copy it. Select sheet 2 and activate (click into) cell you want to be top left corner of data. Right click and select "Paste Special". Select radio button for transpose data. Click ok.

 

[alhurayas]

thank you stiuart_w
but this way it does not update

 

[Stiuart_W]

I appreciate English may not be your first language but you really need to explain EXACTLY what you need.

What I posted will do what you asked but it appears what you need isn't really what you posted.

Perhaps you can start again and describe exactly what you need.

Thanks

 

[Cindy Ellis]

Hello,
The best solution may depend on the amount of data involved. The following formula, copied into cell A1, then copied down and across (by dragging the solid + that shows when you put your cursor over the bottom right of the cell) to the appropriate number of rows and columns, with transpose the data from Sheet 1 into whatever sheet you enter the formula. As written, it will only transpose the first 10 columns. Add more column letters to the list if you have more than 10 columns of data in Sheet1:

=INDIRECT("Sheet1!"& INDEX({"A","B","C","D","E","F","G","H","I","J"},0,ROW()) & COLUMN())

Hope that helps,

 

[alhurayas]

thank you very much Cindy Ellis
this is what I want but if there an easy way because I reached culumn (TD)

 

[markmzz]

Try this array formula (use Ctrl+Shift+Enter and not only Enter):

A1-> =INDEX(IF(Sheet1!$A$1:$E$4="","",Sheet1!$A$1:$E$4),COLUMNS($A1:A1),ROWS(A$1:A1))

Markmzz