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
1	Input	Sheet1	Sheet2	Sheet3
2	a	abcd	abc	????
3	b	bcde	dea
4	c	cdea	bcd
5	d	deab	eab
6	e	eabc	cde
7	f	abcd	abc
8	g	bcde	dea
9	h	cdea	bcd
10	i	deab	eab
11	j	eabc	cde
12	k	abcd	abc
13	l	bcde	dea
14	m	cdea	bcd
15	n	deab	eab
16	o	eabc	cde
17	p
18	q
19	r
20	s
21	t

<tbody>
</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?