Link to home
Start Free TrialLog in
Avatar of Achievement_First
Achievement_First

asked on

How can I fill down vertically from a horizontal data in Excel 2007?

So here's what I want to do.  Worksheet A has cells with drop down answers that users select.  They are organized horizontally (i.e. A1, B1, C1, etc.).  I have another worksheet (Worksheet B) where I would like to list their answers vertically.  So for example:
Worksheet A
Cell A1=True, B1=False, C1=True

What I want is Worksheet B to report the following
Cell A1=A1's answer
Cell A2=B1's answer
Cell A3=C1's answer

So the result would look like this:
Worksheet B
True
False
True

Instead of:
Worksheet A
True False True

I can't use the fill down option and it's driving me nuts.  Please help.
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Put this in 'Worksheet B'!A1 and copy down as needed:

=INDEX('Worksheet A'!1:1,1,ROW())
You can Copy and Paste Special-Transpose the data from sheet1 to sheet2.
SOLUTION
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Achievement_First
Achievement_First

ASKER

So that I can customize the formula to fit my specific need, can you explain what the $1:$1,1,ROW()) means in the formula.  I'm close but not quite there.

BTW, I've already tried transpose and it doesn't work.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Awesome, it worked!  
How did you guys get so smart?
Thanks for elaborating on the formula also, this made it much easier to understand what to look for.