Values shown horizontally, but want to drag it down to show vertically

[CharneLewis]

Hi Mr Excel,

I would like to know what formula can I use to drag the values in E7:L7 in cells H137:H144. Currently I just linked it as =E7; =F7 etc. But want to be effective and time saving while doing this.

Best regards,

 

[Cubist]

Try

=TRANSPOSE(E7:L7)

 

[kevin9999]

Would Transpose work for you? Something like this:

Book1
	E	F	G	H	I	J	K	L
7	8,604,168	7,897,117	4,807,896	8,718,117	5,045,611	7,956,887	7,568,684	7,735,694
8
9
10				8,604,168
11				7,897,117
12				4,807,896
13				8,718,117
14				5,045,611
15				7,956,887
16				7,568,684
17				7,735,694
Sheet1

Cell Formulas
Range	Formula
H10:H17	H10	=TRANSPOSE(E7:L7)
Dynamic array formulas.

 

[Fluff]

Another option is

=tocol(e7:l7)

 

[CharneLewis]

Would Transpose work for you? Something like this:

Book1
	E	F	G	H	I	J	K	L
7	8,604,168	7,897,117	4,807,896	8,718,117	5,045,611	7,956,887	7,568,684	7,735,694
8
9
10				8,604,168
11				7,897,117
12				4,807,896
13				8,718,117
14				5,045,611
15				7,956,887
16				7,568,684
17				7,735,694
Sheet1

Cell Formulas
Range	Formula
H10:H17	H10	=TRANSPOSE(E7:L7)
Dynamic array formulas.

Thank you, it is working but not on the sheet I need it to work. I've tried your example in a new book and it worked perfectly. So don't know why it doesn't work on my current excel workbook.

Don't you know of an offset function? I've seen it, but can't seem to figure out how it is working.

 

[Fluff]

it is working but not on the sheet I need it to work.

In what way doesn't it work?
Also did you try the formula I suggested?

 

[Peter_SSs]

doesn't work

What does "doesn't work" mean?
- Error value (what error?)
- Wrong values returned (what values?)
- Crashes excel?
- Nothing returned?
- something else?

Can you give a small sample that is not working with XL2BB?