How do I combine rows without a pivot table?

Content

Is there any easy way to collapse these rows within a table through SQL?   I want one row per req, with each variable in it's own column.  Each of these variables are from transaction events/comments.