Consolidating source multiple rows into 1 row

Hi all, looking for some helpful hints to point me in the right direction for combining multiple incoming transactional rows for an ID into 1 output row to be used for reporting.   Each row is ide...