can Excel do this what I called 'group' of records ?

Occasional Visitor

I remember the basis spreadsheet in my time can simply do follows:

 

from :

 

NameCell AddressCountry 
aaa478738fdjkaljdfusa 
bbb433828kdjfdksajkusa 
ccc38888kfdjkduk 
ddd3838383slkdkdjfuk 
eee9989789fjkdakdchina 
fff999999kklkdkkchina 
     

 

to 'group'ed by 'country' to : 

 

CountryNameCell Address
usa   
 aaa478738fdjkaljdf
 bbb433828kdjfdksajk
uk   
 ccc38888kfdjkd
 ddd3838383slkdkdjf
china   
 eee9989789fjkdakd
 fff999999kklkdkk

 

 

I do not use number counting, and I do not use calcuation of records,, I just want this grouping of records by 'column' , but I did not find any function available in Excel.

 

can any Expert help me ?

 

1 Reply

Hi,

 

You could do this using the PivotTable as below screenshot:

Pivot Table - Grouping.png

 

Please find the attached file.

Regards