Converting rows in colomns

Hi

I have a table with formulas on one worksheet which has 4 rows and 10 columns. On a second worksheet i have a table with 10 rows en 4 columns. The table on the second page should show the data from the first page. I want to link these with ='Val Data'!L4.

this means the first and second column would look something like this:

='Val Data'!B3 ='Val Data'!B4 ='Val Data'!B5
='Val Data'!C3 ='Val Data'!C4 ='Val Data'!C5
='Val Data'!D3 ='Val Data'!D4 ='Val Data'!D5
..... ....... .......
..... ....... .......

Is there any way to do this with the fill function or any other method because my job is boring enough as it is

Until now iv tried a lot of different fill function options and the paste special
but to no avail.

Thanks a lot

Cheers,

Cyril

Hi Cyril

Have you tried Copy >Paste special >transpose?

Ed

Hi Ed

thanks for the dazling fast answer, yes i did try that but it didnt work. However i just found out using the transpose function as an array did work.

http://www.techonthenet.com/excel/fo.../transpose.php

Cheers!

Cyril

Hi Cyril,

Glad you got it sorted - have you looked at www.ASAP-Utililities.com, lots of useful functions as an add-in there.

Ed