Multi-Row Data Consolidation Into Single Row, Multi-Column

I've been searching for a simple, easily repeatable solution to reformat a report that I generate on a biweekly basis.     In column A, we have the asset tags of a primary piece of equipment. ...