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())