Increment cell reference after nth row.

[sshirazi]

Col A Col B
Text1 Text1
Text2 Text1
Text3 Text1
Text4 Text1
Text5 Text2
Text6 Text2
Text2
Text2
Text3
Text3
Text3
Text3

Need a formula in column B to copy data from Col A & increment the reference every 5th row as above.
Column A is over 2,000 line item. Please help!

 

[Peter_SSs]

See if you can adapt this to suit what you want. Formula in B2 is copied down.

Excel Workbook
	A	B
1
2	Text1	Text1
3	Text2	Text1
4	Text3	Text1
5	Text4	Text1
6	Text5	Text2
7	Text6	Text2
8	Text2	Text2
9	Text2	Text2
10	Text3	Text3
11	Text3	Text3
12	Text3	Text3
13	Text3	Text3
14		Text4
15		Text4
16		Text4
17		Text4
18		Text5
19		Text5
Repeat Values