Excel's 'Flash Fill' feature has concatenated this complex data so easily without using any formula.