Data viewing: getting data from each file appear in one single row


I am getting ready to analyze my data, and I need to combine all data files into one single file in which each row corresponds to one single data file.
The first part (merging the files) is easily done with superlab data viewer, but I am struggling with the next step(s).

Does anyone know a way to have all data from each file appear in one row, instead of several lines and rows? (in superlab data viewer or excel)

I am attaching a screenshot to illustrate the desired output.

Thank you for any suggestion you may have !

Screen Shot 2017-05-24 at 9.46.00 PM.png