Rows to Columns not using paste special or transpose function

[cafeaulait]

Hi all

I need a formula to transpose rows to columns of a large table. The transpose array formula is not working for me. I know there is a column and row function formula to do this, but I can't remember it. It's in the Mr Excel book, which I don't have with me at the moment. Does anyone know the formula??

 

[Peter_SSs]

Note that I have removed your email address from your post. Refer to point 19 of the Posting Guidelines

Is this what you want? The formula in G3 is copied across and down.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K
2
3		a	e	i			a	b	c	d
4		b	f	j			e	f	g	h
5		c	g	k			i	j	k	l
6		d	h	l
7
Transpose

 

[cafeaulait]

thanks will this do rows to columns? or will the formula need to be changed?

 

[Peter_SSs]

thanks will this do rows to columns? or will the formula need to be changed?

Does it not already do that? In my example, row 3 in the left table becomes a column (G) in the right table etc.