Transposing help needed (simple)

[ArPharazon]

I've looked at some past transposition help threads and they seem to be dealing with much more complicated formulas than what I'd like to do today and in the future.

I have special pasted info from my chat's banned user lists and they are in groups of 4 rows per "entry"

I only want to transpose each group of 4 rows (1 column) into 1 row (4 columns)

I can do this manually by selecting and copying 4 cells and transposing them into a cell to the right.

The question is, is there a simple formula I can use for this?

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F
1
2	a1		a1	b1	c1	d1
3	b1		a2	b2	c2	d2
4	c1		a3	b3	c3	d3
5	d1		a4	b4	c4	d4
6	a2		a5	b5	c5	d5
7	b2		a6	b6	c6	d6
8	c2
9	d2
10	a3
11	b3
12	c3
13	d3
14	a4
15	b4
16	c4
17	d4
18	a5
19	b5
20	c5
21	d5
22	a6
23	b6
24	c6
25	d6
Main

Cell Formulas
Range	Formula
C2:F7	C2	=INDEX($A$2:$A$25,(ROWS(C$2:C2)-1)*4+COLUMNS($C2:C2))

 

[ArPharazon]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F
1
2	a1		a1	b1	c1	d1
3	b1		a2	b2	c2	d2
4	c1		a3	b3	c3	d3
5	d1		a4	b4	c4	d4
6	a2		a5	b5	c5	d5
7	b2		a6	b6	c6	d6
8	c2
9	d2
10	a3
11	b3
12	c3
13	d3
14	a4
15	b4
16	c4
17	d4
18	a5
19	b5
20	c5
21	d5
22	a6
23	b6
24	c6
25	d6
Main

Cell Formulas
Range	Formula
C2:F7	C2	=INDEX($A$2:$A$25,(ROWS(C$2:C2)-1)*4+COLUMNS($C2:C2))

Thank you!!!! That did exactly what I needed.

Seems similar to another formula I used to use to find distinct names in a column, where you pull down until there's no more info to be found.

 

[Fluff]

You're welcome & thanks for the feedback.