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 ?
