Using GROUP_CONCAT and SUBSTRING_INDEX to emulate a vertical row COALESCE for columns.
Posted on 28 December 2017