How to skip number of rows from list

[satish78]

Hi Friends,

I have five spreadsheets in which each spreadsheet contains 100 rows of text(instead of text I put a1, a2, a3 row names to easy construct formula but its kind of confusing to me).
looking for a formula which can skip every:
1 row in sheet1
2 rows in sheet2
3 rows in sheet3
4 rows in sheet4
5 rows in sheet5

Below is a small example
Sheet1
columnB:row1=a1&a2&a3&a4
columnB:row2=a2&a3&a4&a5
columnB:row3=a3&a4&a5&a1
columnB:row4=a4&a5&a1&a2
columnB:row5=a5&a1&a2&a3
so on till 100th row

Sheet2
columnB:row1=a1&a2&a3
columnB:row2=a4&a5&a1
columnB:row3=a2&a3&a4
columnB:row4=a5&a1&a2
columnB:row5=a3&a4&a5
so on till 100th row

like above 2 examples in 2 sheets and also in 3, 4, 5 sheets till 100th row
Can anyone help me with this task
sample attachment
https://mab.to/3TSC9tdpL

 

[StephenCrump]

... but its kind of confusing to me.

Yes, me too!

Based on what you've said, it sounds like you're expecting to see this output in Sheet1 and Sheet2? I don't know how this would generalise to Sheets 3, 4 and 5?

What output are you actually expecting to see?

	A	B	C	D
Sheet1	Sheet2	Sheet3
a	abcd	abc	????
b	bcde	dea
c	cdea	bcd
d	deab	eab
e	eabc	cde
f	abcd	abc
g	bcde	dea
h	cdea	bcd
i	deab	eab
j	eabc	cde
k	abcd	abc
l	bcde	dea
m	cdea	bcd
n	deab	eab
o	eabc	cde
p
q
r
s
t

<tbody>
[TD="align: center"]1[/TD]
[TD="align: right"]Input[/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"][/TD]

[TD="align: center"]4[/TD]

[TD="align: right"][/TD]

[TD="align: center"]5[/TD]

[TD="align: right"][/TD]

[TD="align: center"]6[/TD]

[TD="align: right"][/TD]

[TD="align: center"]7[/TD]

[TD="align: right"][/TD]

[TD="align: center"]8[/TD]

[TD="align: right"][/TD]

[TD="align: center"]9[/TD]

[TD="align: right"][/TD]

[TD="align: center"]10[/TD]

[TD="align: right"][/TD]

[TD="align: center"]11[/TD]

[TD="align: right"][/TD]

[TD="align: center"]12[/TD]

[TD="align: right"][/TD]

[TD="align: center"]13[/TD]

[TD="align: right"][/TD]

[TD="align: center"]14[/TD]

[TD="align: right"][/TD]

[TD="align: center"]15[/TD]

[TD="align: right"][/TD]

[TD="align: center"]16[/TD]

[TD="align: right"][/TD]

[TD="align: center"]17[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]18[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]19[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]20[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]21[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

 

[FDibbins]

Are you trying to combine the cells into 1 cell (text) or add the cell contents into 1 cell (numeric)

What exactly are you trying to do here, can you show a sample of your data/answers?