Hello,

Based on this site: http://support.microsoft.com/?kbid=214024

The following formula converts rows to columns in the same sheet.

=OFFSET($A$1,(ROW()-1)*4+INT((COLUMN()-3)),MOD(COLUMN()-3,1))


How can I convert columns to rows and between sheets, such as take all the
columns for row=2 in sheet1 and link it to column B in Sheet2 (not through
paste special, the link should be created between sheet1 and sheet2)

Any help will be greatly appointed.