Fill down with spacing of rows? E.g. 1,2,3,4 aligns to 1,3,5,7,9

[abssorb]

I have a template spreadsheet for tracking forecast and actual figures, which will be used by many people as so needs to be flexible.

On a summary worksheet, there are rows summarising process data in section 1, with one summary per row. It picks up its data from section 2 in another sheet, where the data is on two rows per process.

Need Section 1 to be flexible enough to fill down, add rows etc. so the increment in the formula needs to be two rows.
Process A refers to rows 6 and 7
Process B refers to rows 8 and 9
So a fill down needs to go 6,8,10,12 etc. Or need some formulaic method

I've have a sample which I hope explains the problem.
https://nofile.io/f/aya6YdKv3OH/Fill+down+double+row+problem+1.xlsx

Advice and ideas most welcome

 

[Snakehips]

abssorb,

Cannot view your sample.

Do you want something like...

Excel 2010
	A	B
5
6	ProcessA	A line 1
7		A line 2
8	ProcessB	B line 1
9		B line 2
10	ProcessC	C line 1
11		C line 2
12	ProcessD	D line 1
13		D line 2
14	ProcessE	E line 1
15		E line 2
16
Sheet2

Excel 2010
	A	B
1
2	Process A	A line 1 A line 2
3	Process B	B line 1 B line 2
4	Process C	C line 1 C line 2
5	Process D	D line 1 D line 2
6	Process E	E line 1 E line 2
7
Sheet1

Cell Formulas
Range	Formula
B2	=INDEX(Sheet2!B6:B1000,ROWS(A$2:A2))& " " & INDEX(Sheet2!B6:B1000,ROWS(A$2:A2)+1)

Hope that helps.

 

[abssorb]

Hi Tony, apologies for the delay in replying. That worked perfectly! Thank you