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