25 Jun 2017. Comments 0. How to make a consolidated table in Excel 2003, 2007, 2010 with Formulas: Step-by-step instructions