Hi Experts
I run into a problem I can't seem to be able to resolve or find the solution to. Basically I have a list of sample data as follow -
Country Company
------- --------
US Wal Mart
UK Tesco
US Exxon Mobil
UK BP
I would like to present them in a report with higher readability, so I sort by country and hide the repeated entry in "Country". The result is as follow -
Country Company
------- --------
US Wal Mart
..... Exxon Mobil
UK Tesco
..... BP
However I also need to add in a blank row or some blank space between distinct country, as follow -
Country Company
------- --------
US Wal Mart
..... Exxon Mobil
------ blank row or some blank space ----------
UK Tesco
..... BP
I couldn't find a way to do this, any input would be highly appreciated. Thanks in advance!
power2005
I run into a problem I can't seem to be able to resolve or find the solution to. Basically I have a list of sample data as follow -
Country Company
------- --------
US Wal Mart
UK Tesco
US Exxon Mobil
UK BP
I would like to present them in a report with higher readability, so I sort by country and hide the repeated entry in "Country". The result is as follow -
Country Company
------- --------
US Wal Mart
..... Exxon Mobil
UK Tesco
..... BP
However I also need to add in a blank row or some blank space between distinct country, as follow -
Country Company
------- --------
US Wal Mart
..... Exxon Mobil
------ blank row or some blank space ----------
UK Tesco
..... BP
I couldn't find a way to do this, any input would be highly appreciated. Thanks in advance!
power2005
Comment