Multiple Rows in Single Row

building reports webintelligence
1

Hi is it possible to get multiple row data in a single row separated by ; in Webi
ex:
Country City
US New York
US Washington
UK London
UK Liverpool

as
Country City
US New York; Washington
UK London ; LiverPool

zaif235 :us: (BOB member since 2010-06-15)

2

https://bobj-board.org/t/157936

Prashant Purohit :india: (BOB member since 2009-02-18)

3

Moderator note:
Closing the topic to avoid fragmented discussion.

Thanks.

Marek Chladny :slovakia: (BOB member since 2003-11-27)