Split data column in more columns

Hi all, test.xlsx file contains a table and two examples of how I want to break that column (COD), has anyone a VBA code or something like this to breaking the column and arranging them according to certain data from a column??? Thank you in advance for your help ... and I wish you all a beautiful day

Try this:-
Data sheet1, Results Sheet2.

Please Login or Register  to view this content.

Regards Mick

THAKS MickG, WORK FINE

You're welcome

HI MickG, I would like if you can still take a look at a file attached table test2 (Sheet1) ... my question is: can rearrange the structure of table in the Sheet1 in a new table Sheet2 example(look in the sheet2 pls) with a VBA code (you have such a code).Thanks

HELLO Mick, I have no words, VBA code works perfectly ... thank you so much.

You're welcome