Group data by Identifier in one column, then sort based on Identifier in another

[lostballtallweeds]

Hello all, and thank you for everyone's time in providing this valuable resource. I spend a lot of time manually sorting data that is pulled from a database and hope to be able to streamline the process, but so far I have struck out in using different combinations of VLOOKUP AND Match/Index. I'm hoping that someone here can point me in the right direction.



[TABLE="width: 500"]
<tbody>[TR]
[TD]10100[/TD]
[TD]F1[/TD]
[TD]99[/TD]
[TD]OQ[/TD]
[/TR]
[TR]
[TD]34567[/TD]
[TD]R1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10100[/TD]
[TD]R2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10100[/TD]
[TD]R3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10100[/TD]
[TD]F2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10100[/TD]
[TD]T[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10100[/TD]
[TD]R1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]34567[/TD]
[TD]R2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]34567[/TD]
[TD]T[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]34567[/TD]
[TD]F1[/TD]
[TD]98[/TD]
[TD]OQ[/TD]
[/TR]
</tbody>[/TABLE]

I need the data from the chart above to be returned on a different sheet in the same workbook as-



[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]10100[/TD]
[TD]99[/TD]
[TD]OQ[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]R1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]R2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]R3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]T[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]F1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]F2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]34567[/TD]
[TD]98[/TD]
[TD]OQ[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]R1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]R2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]T[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]F1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

This is far beyond my skill level, but I hope someone out there has a solution for me.