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!
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!