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.
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.
You can Copy and Paste Special-Transpose the data from sheet1 to sheet2.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
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.
BTW, I've already tried transpose and it doesn't work.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
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.
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.
=INDEX('Worksheet A'!1:1,1,ROW())