Sorry the data layout is not easy to understand

Source data

Index Unit Patch Folder No.
1 D0X D2X 1
2 D0X D2X 1
3 D0X D2X 1
4 D0X D2X 1
5 D0X D2X 1
6 D0X D2X 1
7 D0X D2X 1
8 D0X D2X 1
9 D0X D3X 1
10 D0X D3X 1
11 D0X D3X 1
12 D0X D5X 1
13 D0X D5X 1
14 D0X D6X 1
15 D0X D6X 1
16 D0X D6X 1
17 D0X D8X 1
18 D0X D8X 1
19 D0X D8X 1
20 D0X D8X 1
21 D0X D8X 1
22 D0X D8X 1
23 D0X D8X 1
24 D0X D8X 1
25 D0X D8X 1
26 D0X D8X 1
27 D0X D9X 1
28 D0X D9X 1
29 D0X D9X 1
30 D0X D9X 1
31 D0X D9X 2
32 D0X D9X 2
33 D0X D9X 2
34 D0X D9X 2
35 D0X D9X 2


What I need to do is match the Unit to the folder Number and return the min
and max index numbers, all the patches contained within that range and the
folder number with the Max folder number after that (eg. 1 of 6)

Output

Index Start Index End Unit Patch
Folder No.
1 30 D0X D2X, D3X, D5X, D6X, D8X,
D9X 1 OF 6
31 45 D0X D9X, DAX
2 OF 6
46 49 D0X DAX
3 OF 6
50 79 D0X DDX, DEX, DFX
4 OF 6
80 92 D0X DFX, DGX
5 OF 6
93 107 D0X DGX, DHX, DJX, DKX
6 OF 6

Any and all help would be greatly appreciated.

Regards

Mick