How to convert column multivalue field to a single row

[mlevsh]

Hi,

I need to get the list of indexes with the roles on them.
I use the following search:

| rest /services/authorization/roles splunk_server="local"
| table title, srchIndexesAllowed

The result is displayed in the following format:
     index1   role1
                      role2
     index2   role1
                      role3

How do I display it in the following form:
     index1 role1 role2
     index2  role1 role3 

Thank you!

[ITWhisperer]

It is not clear whether you expect the roles to be in separate fields or a single (string) field

| mvcombine role | nomv role