Data in Columns to also display in Rows

[st1366]

Hi

I need data calculated in columns to display in a row in a seperate worksheet.

Example: I want Cell J6 to show the data in B16 and K6 to display the data in B17 and so on.

Is there a formula etc. I can use as I have a lot of data to move.

thanks

[iuliaboboc]

copy, paste special and select transpose (bottom right, just neat OK button)

[st1366]

Thanks, but I need to keep the formula link as the data in the column changes continually and the rows must always display the same numbers as the columns.

[iuliaboboc]

select b9-b12
write formula = transpose(i5:l5)
press ctrl, shift, enter at the same time