You will have to manually link the cells. A short-cut is as follows:
Lets say your table is in range A1:G7 inclusing the headers. Select
cells B3:B7, and enter the formula =TRANSPOSE(IF(C2:G2="","",C2:G2)).
Press control shift enter. The upper right corner of your matrix is the
input part, and the lower left corner contains the formulae to the upper
right corner. Repeat the procedure for cells C4:C7 and so on.

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=393211