Need to consolidate data, pulling data from rows that fit criteria

Hey Excelforum,

I have been trying all week unsuccessfully trying achieve the following in excel . There is around 1700 unique ID's that I need to do this for so it would ultimately have to be a formula that can be applied to each column. It does not matter which date is populated if there is more than 1 option for a column.

Here is the test file - Example.xlsx

Remove duplicates removes all duplicate information and does not really achieve anything. I have tried using a pivot table hoping that it would remove duplicate ID's and populate all fields. I have also tried using vlookup and index(...., match(....)) to return dates in the cells but this also does not work. I cannot think of anything else, does any one have any ideas that may help?

Thanks!

Please upload the actual example workbook that you used for your picture (Go Advanced>Manage Attachments) That will help us try out some solutions.

Hi

B17

Formula:

Please Login or Register  to view this content.

This is array formula! Press same time: Ctrl+Shift+Enter, NOT ENTER. Copy down

C17

Formula:

Please Login or Register  to view this content.

Array formula Ctrl+Shift+Enter. Copy down

This formula will give you Alphabetically order

See the file!

Regard