OK, I'm not getting any closer to understanding what you want.

Can you provide some sample data showing what you currently have and what you want to have?