[solved] VBA to sort single list of data into categories

Hello,

I have two columns of data, where A is a set of 7 repeating categories, and B has the corresponding value.

I need to sort this data so that I have the 7 categories on a single row, and all the data listed for each category.

I guess VBA is the answer. Maybe even some fancy Excel formula would do the trick.

Attached file.

I use excel 2019

Edit:
Never mind, I figured this out myself with some regular Excel formula.