Horizontal Sort

My apologies...
I didn't realize that was repetitive. The answer that was not in the first post was that you, in fact, know what the ID is as it is ALWAYS in Column A. I'm sorry if that was unclear.
Attached is a view of:

• how it is exported (in theory as the data is confidential),
• how I use 'text to columns' to separate, and
• the ideal output

thanks all!
jg