Every 5 groups of rows

[ksclans]

I don't really know what kind of terms I am looking for so I did my best searching around...

so I trying to move contents of column A and move to column B
But I want the 5 cells of A to 1 cell of B
A1 - A5 to B1
A6 - A10 to B2
A11 - A 15 to B3
.
.
.
thanks for helping..

[stanleydgromjr]

ksclans,

Welcome to the Excel Forum.

If:
A1 = 1
A2 = 11
A3 = 111
A4 = 1111
A5 = 11111

What will B1 look like?
1,11,111,1111,11111
or
1, 11, 111, 1111, 11111

[ksclans]

well if B1 can have a new line within the cell when transfer content A1 - 5 that would be better... so looks like
"
1
11
111
1111
11111
"

what I am trying to do is to select groups of 5s without using my mouse to select them and counting 1, 2, 3, 4, 5.. if this works then I just need to select one cell.. thanks

[stanleydgromjr]

ksclans,

Can I see a workbook with examples of numbers in column A, A1 thru A15, and what column B will look like?

Please post your workbook (or a sample) by clicking on the New Post button, then scroll down and click on the Manage Attachments button.

[JBeaucaire]

Something like this in B1, then copy that cell downward:

=INDEX(A:A,((ROW()-1)*5)+1) & INDEX(A:A,((ROW()-1)*5)+2) & INDEX(A:A,((ROW()-1)*5)+3) & INDEX(A:A,((ROW()-1)*5)+4) & INDEX(A:A,(ROW()*5))

[Marcol]

Let's get the ball rolling....
Assuming data is in column A

Please Login or Register  to view this content.

Drag/Fill Down

Just one way to draw teeth...

[EDIT]
Apologies Jerry posts crossed