Group rows based on a cell value

[alexpantex]

Hi everyone,

I am new to macros, and now I'm facing a problem, where I would need your suggestions.
I need to group rows in 3 levels, on first level we should only see manufacturers, on 2nd brands and on 3rd items. I thought it would be easier to group it based on a value in cell A, and based on a number in cell to group data.


for example

A B C D
1 man1
2 brand1
3 item
1 man2
2 brand1
3 item
3 item
2 brand2
etc..


If you have any suggestions or ideas, it would be great. Thank you all

 

[alexpantex]

Wikisend: free file sharing service macro grouping.xlsx

this is file example