Transform List into Grid/2D table

Hello,

I am trying to transform a database like list into a 2d table. Something like this:

From:
Category_A Sub-Cat 1 Text1
Category_A Sub-Cat 1 Text2
Category_A Sub-Cat 1 Text3
Category_A Sub-Cat 2 Text4
Category_A Sub-Cat 2 Text5
Category_A Sub-Cat 3 Text6
Category_A Sub-Cat 3 Text7
Category_A Sub-Cat 3 Text8
Category_B Sub-Cat 4 Text9
Category_B Sub-Cat 4 Text10
Category_B Sub-Cat 4 Text11
Category_B Sub-Cat 5 Text12
Category_B Sub-Cat 5 Text13
Category_B Sub-Cat 5 Text14
Category_C Sub-Cat 6 Text15
Category_C Sub-Cat 6 Text16
Category_C Sub-Cat 6 Text17

into:

Category_A Sub-Cat1 Text1 Text2 Text3
Category_A Sub-Cat2 Text4 Text5
Category_A Sub-Cat3 Text6 Text7 Text8
Category_B Sub-Cat4 Text9 Text10 Text11
Category_B Sub-Cat5 Text12 Text13 Text14
Category_C Sub-Cat6 Text15 Text16 Text17

is there any formula I could use? Or do I need a macro?

Thanks a lot for your help!

BR
Stephan

Which Excel version do you have (2016, 2019, 365)? Answers can differ depending on your version.

Excel 16.49 on Mac (Office 2019), I could also use Excel (16.0) on Windows.

Thanks for your support!

Attachment 734081

Thanks a lot for taking the time to help me!

This link you sent is really useful, I was not aware of that with Pivot Table. Unfortunately, I realized that I did not described my issue well enough. I have now taken a screenshot of what I mean in excel, I hope it is better now. Sorry for this. Do you see an easy way to do this? Is it possible with Pivot Table?

Thanks again!