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.