Merge Cells from Different Rows

I see that there are a few posts similar to this one and I have tried a few but I haven't ended up with quite the results needed. I have a spreadsheet that may have 1000 rows on this spreadsheet but the next spreadsheet it may have 150,000 rows.

Goal:

1. Sort Spreadsheet by Column A (Client_ID)
2. If A2 = A1 then F1 = F1, F2
3. Delete row 2
4. Then again, if A2 = A1 the F1 = F1, F2

The end result should be 1 unique row with all of the merged "Status" in Column F. The word "Status" does not have to be static, in other words, the next spreadsheet may be the word "Stocks" for Column F header. Attached is the sample spreadsheet with 6 columns. The Unique Identifier is in Column A (Client_ID) and the data that I would like to have merged is in Column F (Status).
I have also attached a word doc that I wrote up for the manual way of completing what I need to get done. It works but ofcourse it is so time consuming if a particular client ID is listed in 25 rows.

Thank you for your time.

Try this:

Please Login or Register  to view this content.

Thanks that worked like a charm. I did try one of the ones that you posted to someone at an earlier date but that seemed to lock up a bit. I figured that you would see this post and reply, thanks again that was a huge help.