How do I combine multiple rows in neo4j?

Question

I have the following nodes:

p:Person
s:Skill

And the relationship is: (p)-[KNOWS]-(s).

My query is:

MATCH (p:Person)-[r:KNOWS]->(s:Skill) 
WHERE p.Name=~'Julie.*' 
RETURN (p.Name),(s.Name)

The Output is:

╒════════════╤══════════════════════════════╕
│(p.Name)    │(s.Name)                      │
╞════════════╪══════════════════════════════╡
│Julie Rocha │Knowledge Management          |
├────────────┼──────────────────────────────┤
│Julie Rocha │MongoDB                       │
└────────────┴──────────────────────────────┘

The Desired Output is:

╒════════════╤══════════════════════════════╕
│(p.Name)    │(s.Name)                      │
╞════════════╪══════════════════════════════╡
│Julie Rocha │Knowledge Management, MongoDB |
└────────────┴──────────────────────────────┘

How can I accomplish this? Any help is appreciated!

Answer 1

Use collect():

MATCH (p:Person)-[r:KNOWS]->(s:Skill) 
WHERE p.Name =~ 'Julie.*' 
RETURN p.Name, collect(s.Name) AS skill

In the result, the skill attribute will be a list.