2 columns data split to more columns based on groups in 2nd column

Hello,

could you please help me with macro solution for topic below?
I need to reorganize data from A:B area based on values in B columns, as visible on image.


I guess that this simple topic was already discussed somewhere - unfortunately I was not sucessfull to find it in forum.

example.JPG

Thank you for help with macro code.

vm

Untested as no sample workbook provided (it's ALWAYS easier to help with a sample workbook!), but try the below and see if that works.

Please Login or Register  to view this content.

Beth.

Hello, great, thank you for very quick answer - works as requested.
sorry for not adding of workbook.

topic solved.
vendam

Glad I could help.

Beth.