Meging info in table

I have a long table with names (Given Name, S/Name, Family name) and some info data for each person in a separate column of the table (left side of the attached files)
I ‘d like to merge info for each person in a line. (right side of example). If there is no info line stays empty.
Since table is long enough and cannot use & for each name separately is there any other way to merge info ?
Thanks in advance for your help

Try this on a backup copy of your data:

1) Put this formula in E4, then copy that cell down to the bottom of the data:

=IF(D4="","", IF(E5<>"",D4&","&E5,D4))

2) Highlight the new data in column E and COPY it

3) Click on the D4 and select Edit > Paste Special > Values

4) Clear column E

5) Click on column C and press F5

6) Select Blanks and click OK

7) Select Edit > Delete > Entire Row