Linking a Column List to a Row List

M

Moe

I would appreciate any help on this, I'm trying to finish a report i
the next hour or so, and I need to know how to do this (sounds prett
straight forward):

I have a list of Items in a "column", and all I want to do is link tha
list to another sheet, but I need the info to be in a "row" on the ne
sheet. I don't want to just paste the data, I need it be linked. Ex.
A1=Box, A2=Paper, A3=Pen, I need this to show up on the new sheet as
B1=Box, C1=Paper, D1=Pen.

I know there's a vba option of doing this, but can I do this with a
excel formula? Perhaps using offset or another similar function?

Thanks a million to whoever can help me.

Mo
 
F

Frank Kabel

Hi
in B1 enter the following formula:
=OFFSET($A$1,COLUMN()-COLUMN($B$1),0)
and copy this to the right
 
A

Aladin Akyurek

=INDEX(Source!$A$1:$A$10,COLUMN()-COLUMN($B$1)+1)

which is entered in B1 & copied across. Replace 'Source' with the nam
of the sheet that holds the data you want to link to.
 
Top