PostgreSQL Export to CSV. Each element of array in new line I have next request

\copy (
  SELECT users.name, ARRAY_AGG(emails.email), ARRAY_AGG(addresses.address)  
  FROM users
  LEFT JOIN emails USING(id)
  LEFT JOIN addresses USING(id)
  GROUP BY users.email
) TO 'path/to/file.csv' WITH csv header;


and it exports data in next way

|John Doe|{email1@qq.qq,email2@qq.qq}|{addr1,addr2}|


is it possible to export array in multiline cell? To have next view

-----------------------------
|John Doe|aaaaa1@aa.aa|addr1|
|        |aaaaa2@aa.aa|addr2|
-----------------------------
|Foo Bar |bbbbb1@bb.bb|addr9|
|        |bbbbb2@bb.bb|addr8|
|        |bbbbb3@bb.bb|     |
-----------------------------


I've tried to join array into a string with \r\n, but it doesn't work

Is it possible at all?
Test:

\copy (
  SELECT CASE WHEN users.name = LAG(users.name) OVER (ORDER BY users.name, 
                                                               users.email, 
                                                               addresses.address) 
              THEN '' 
              ELSE users.name
              END, 
         emails.email, 
         addresses.address
  FROM users
  LEFT JOIN emails USING(id)
  LEFT JOIN addresses USING(id)
  ORDER BY users.name, 
           users.email, 
           addresses.address
) TO 'path/to/file.csv' WITH csv header;