Mix the field string value

Hello, Experts

i am the newcomer for the Influxdb
i want to get the one line printout by mix/merge different field value, like the following , (Mix or Merge is method what i assume)

select mix(value) from test group by “name”
name: test
tags: name=“case1”
time mix/merge


1970-01-01T00:00:00Z failed,passed,skipped

select * from test group by “name”
name: test
tags: name=“case1”
time caseAuthor caseName caseResult value


2018-07-20T03:51:42.599533888Z mike case1 pass 1
2018-07-20T03:51:42.690955475Z mike case1 failed 2
2018-07-20T03:51:42.723272883Z mike case1 skipped 3

thanks for any help
BRs
/Yijun