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. 10100 F1 99 OQ 34567 R1 10100 R2 10100 R3 10100 F2 10100 T 10100 R1 34567 R2 34567 T 34567 F1 98 OQ I need the data from the chart above to be returned on a different sheet in the same workbook as- 10100 99 OQ R1 R2 R3 T F1 F2 34567 98 OQ R1 R2 T F1 This is far beyond my skill level, but I hope someone out there has a solution for me.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

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

Thread starter lostballtallweeds
Start date Oct 25, 2018
Tags

data direction hope identifier time

lostballtallweeds

New Member

Oct 25, 2018

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.