Format table

[rissois]

I've a search that return a table like this:

column1             column2               column3

      a                            x                           value1

                                                                 value2

                                                                  value3

      b                            y                           value1

                                                                  value2

                                                                  value3

I need column3 values ​​to appear separated by "|", like this:

column1             column2               column3

      a                            x                           value1|value2|value3

      b                            y                           value1|value2|value3

it is possible format data like this?

[Thulasinathan_M]

Hi,

Append below lines, hope it'll work.

| eval column3 = mvjoin(column3, "|")
| table column1, column2, column3

[rissois]

it works. thank you