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

Question

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

from :

Name	Cell	Address	Country
aaa	478738	fdjkaljdf	usa
bbb	433828	kdjfdksajk	usa
ccc	38888	kfdjkd	uk
ddd	3838383	slkdkdjf	uk
eee	9989789	fjkdakd	china
fff	999999	kklkdkk	china

to 'group'ed by 'country' to :

Country	Name	Cell	Address
usa
	aaa	478738	fdjkaljdf
	bbb	433828	kdjfdksajk
uk
	ccc	38888	kfdjkd
	ddd	3838383	slkdkdjf
china
	eee	9989789	fjkdakd
	fff	999999	kklkdkk

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 ?

haytham amairah · Answer

Hi,&nbsp;You could do this using the PivotTable as below screenshot:&nbsp;Please find the attached file.Regards

Forum Discussion

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

1 Reply

Resources