How to export list/table to excel with blank row as group separator

[Ronnie Babigumira]

Hello,
Hoping someone has a hack to insert a blank row as a group separator when I export a list to excel.

An example

sysuse auto, clear
bys rep78 : keep if _n < 4
l rep78 price, sepby(rep78) noobs

If I copy and paste the above result, as a table, to excel, I get

Any idea how I can do without copy and paste (for large tables)

Thanks in advance

Ronnie

[Jenny Williams]

Try this:

sysuse auto, clear
bys rep78 : keep if _n < 4
l rep78 price, sepby(rep78) noobs

egen seq=seq(), by(rep78)
expand 2 if seq==1, generate(blankrow)
sort rep78 blankrow

replace price=. if blankrow==1
l rep78 price blankrow, sepby(rep78) noobs

replace rep78=. if blankrow==1
l rep78 price, noobs separator(0)

[Ronnie Babigumira]

Many thanks, Jenny.


Ronnie