CREATE TABLE concat_FRA3 AS SELECT Account, Entity, Unit, SUM(Jan) Jan, SUM(Feb) Feb, SUM(Mar) Mar FROM concat_FRA2 GROUP BY Account, Entity, Unit;