Hello everyone,
I am Quan. My dataset is the export value of a country (divided into 6 digit code HS ) to all countries and ranges from 1995-2021.
Now I want to know how the export value has changed for the top 20 importers. Therefore I used the command "bysort year importer: egen exportall=sum(export)"

and I have checked the result with the command " tab importer if year==1995, su(exportall) nost" or "groups importer exportall if year==1995, order(high) select (20) sep(10)" ,
but I applied this command to all years, and when I copy the result to Excel, the importer names could cause an error due to spaces in the country name and different ranks in the different export years.


So my question is if there is a command that outputs the result in STATA as follows: ( if it's not possible, then is there there any better way to output result to the excel without any matches?) Thanks!
exports value 1995 1996 1997 1998 1999 2000 2001
All Sum All Sum All Sum All Sum All Sum All Sum All Sum
country1
country2
country3
country4
country5
country6
country7
country8
country9