Help with advance grouping

Hi,   I’m looking for ways of grouping excel data.   So at the moment I have this data:   ID Field1 Field2 Field3 Field4 NR001 Fixed Text 001-Text DR001 some te...