Merge row which have Common Data

samdemo

Hi,

Is it possible to merge row which have common values?

For eg:
Table have 3 columns : #, Name, Country
Here data is in the form :
ABC, USA
ABC, UK
XYZ, USA
XYZ, CHINA
DEF, BRAZIL

I want to display as :
1, ABC, USA
, , UK
2,XYZ,USA
, ,CHINA
3, DEF, BRAZIL

please anybody guide me suggest me any solution.

Regards & Thanks,
Sam

samdemo

Hi,

I hope someone can give me suggestion or solution to my issue.

Regards & Thanks,
Sam