OFFSET Formula for Multiple Rows

[pyroto]

I am slightly familiar with the OFFSET formula.
I would like to extract the data from Column B into Column F in that order, skip rows and do the same for the data for Tina Fey, etc..
Possibly one continuous formula?
Is this possible?

	A	B	C	D	E	F
1		CLIENT INFO
2	Name	Bob Ross			Date	6/11/2018
3	Item	Paint Brushes			Store	Store 325
4	Cost	$4.25			Name	Bob Ross
5	Discount	$2.00			Item	Paint Brushes
6	Store	Store 325			Cost	$4.25
7	Date	6/11/2018			Discount	$2.00
8
9
10
11
12
13
14
15
16	Name	Tina Fey			Date	6/15/2018
17	Item	Microphone			Store	Store 423
18	Cost	$99.99			Name	Tina Fey
19	Discount	$15.00			Item	Microphone
20	Store	Store 423			Cost	$99.99
21	Date	6/15/2018			Discount	$15.00
22
23
24
25
26
27
28

<tbody>
</tbody>

 

[Eric W]

You could do something like this:

	A	B	C	D	E	F
1		CLIENT INFO
2	Name	Bob Ross			Date	43262
3	Item	Paint Brushes			Store	Store 325
4	Cost	$4.25			Name	Bob Ross
5	Discount	$2.00			Item	Paint Brushes
6	Store	Store 325			Cost	4.25
7	Date	6/11/2018			Discount	2
8
9
10
11
12
13
14
15
16	Name	Tina Fey			Date	43266
17	Item	Microphone			Store	Store 423
18	Cost	$99.99			Name	Tina Fey
19	Discount	$15.00			Item	Microphone
20	Store	Store 423			Cost	99.99
21	Date	6/15/2018			Discount	15

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet3​

Worksheet Formulas Cell Formula F2 =IF(E2="","",INDEX(OFFSET($B:$B,LOOKUP(2,1/(A$1:A1=""),ROW(A$1:A1)),0,6),MATCH(E2,OFFSET($A:$A,LOOKUP(2,1/(A$1:A1=""),ROW(A$1:A1)),0,6),0))) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Note that you have some formatting issues. You could handle those with 2 Conditional Formatting rules. The first would say, "if the value in column E is 'Date', format column F as a date", and the second one would say, "if the value in E is "Cost" or "Discount", then format as an amount."

 

[pyroto]

This worked perfectly. Thank you very much!

 

[Eric W]

You're welcome!