Getting row sets one below the other.

[PritishD]

Hello Excel Forum,

Wanted to know, if there is a function/formula/process to get a set of rows one below the other.

Kindly refer to the attached sheet, which shows the input and the desired output (also shown below)

Desired Output:

NKE-CH-01
NKE-CH-01_L
NKE-CH-01_XL
NKE-CH-01_XXL
NKE-CH-02
NKE-CH-02_L
NKE-CH-02_XL
NKE-CH-02_XXL
NKE-CH-03
NKE-CH-03_L
NKE-CH-03_XL
NKE-CH-03_XXL
NKE-CH-04
NKE-CH-04_L
NKE-CH-04_XL
NKE-CH-04_XXL

Please write back, in case anyone requires some more information from my end.
Any help will be greatly appreciated!

[Glenn Kennedy]

Hi there.

This will do it.

=IFERROR(INDEX($A$1:$D$4,INT((ROWS($1:1)-1)/4)+1,MOD(ROWS($1:1)-1,4)+1),"")

[PritishD]

@Glenn

Thank you for the help!

Kindly re-visit the desired result that i have mentioned. The result provided by you does not match the 'Desired result' that i have mentioned.

[Glenn Kennedy]

Naggghhh. I always read these posts too quickly!!!

=IFERROR(INDEX($A$1:$D$4,MOD(ROWS($1:1)-1,4)+1,INT((ROWS($1:1)-1)/4)+1),"")

Drag down.