Challenging Formula / Script needed - Does it Fit?

[JumboCactuar]

Hi,
i have the following data

ITEM NO	TYPE	LOCATION	QTY	MAX QTY
11224	PRIORITY	AL4401	4	14
11224	RESERVE	GL1202	12	14
55322	PRIORITY	AL5503	8	23
55322	RESERVE	GL1104	10	23
55322	RESERVE	GL1105	2	23
43112	PRIORITY	AL5512	6	100
43112	RESERVE	GL4401	55	100
67442	PRIORITY	AL5212	14	15
67442	RESERVE	GL1201	5	15
57743	PRIORITY	AL5603	0	5
57743	RESERVE	HL1201	4	5
80888	PRIORITY	BL0102	5	9
80888	RESERVE	GL1203	1	1
80888	RESERVE	HL1204	1	1
80888	RESERVE	GL5503	1	1

<tbody>
</tbody>

I need to do the following:

If Reserve QTY fits into Priority Location then output them like this:

ITEM NO	FROM	TO	QTY
11224	GL1202	AL4401	10
55322	GL1104	AL5503	10
55322	GL1105	AL5503	2
43112	GL4401	AL5512	55
57743	HL1201	AL5603	4
80888	GL1203	BL0102	1
80888	HL1204	BL0102	1
80888	GL5503	BL0102	1

<tbody>
</tbody>

Not even sure how to go about doing this, i thought probably using pivots but its tricky

Appreciate any help

 

[JumboCactuar]

Bump

 

[JumboCactuar]

Bump