Data distribution arrangement

[rap8557]

How can i do this?
I have data in Col A & B like a thousands of data
and now how can i arrange them like the picture below on Col D & E
1.png

Thanks

[alansidman]

Welcome to the Forum, unfortunately:

This is a duplicate post (of a Commercial Services Posting) and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.