Spreadsheet: 45835d1244629911-help-consolidating-data-from-multiple-rows-complexlookup
Sheet: Example

 |  |  |  | StoreChair |  | StoreLamp |  | StoreDesk |  | StoreTable |  | StoreBed |  | Store count | Store | Chair | Lamp | Desk | Table | Bed
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | Ikea1 | Ikea |  |  |  |  | 2002-06-04 00:00:00
 |  |  |  |  |  |  |  | Ikea28/01/2007 | Ikea28/01/2007 |  |  | Ikea10/06/2009 | Ikea10/06/2009Ikea04/06/2002 | Ikea2 | Ikea |  |  | 2007-01-28 00:00:00 |  | 2009-06-10 00:00:00
 |  |  |  |  |  | Ikea08/04/2008 | Ikea08/04/2008 |  | Ikea28/01/2007 |  |  |  | Ikea10/06/2009Ikea04/06/2002 | Ikea3 | Ikea |  | 2008-04-08 00:00:00
 |  |  |  |  |  |  | Ikea08/04/2008 |  | Ikea28/01/2007 | Ikea02/06/2009 | Ikea02/06/2009 |  | Ikea10/06/2009Ikea04/06/2002 | Ikea4 | Ikea |  |  |  | 2009-06-02 00:00:00
 |  |  |  | Ikea08/02/2004 | Ikea08/02/2004 |  | Ikea08/04/2008 |  | Ikea28/01/2007 |  | Ikea02/06/2009 |  | Ikea10/06/2009Ikea04/06/2002 | Ikea5 | Ikea | 2004-02-08 00:00:00
 |  |  |  | Office Max14/11/2009 | Office Max14/11/2009Ikea08/02/2004 |  | Ikea08/04/2008 |  | Ikea28/01/2007 |  | Ikea02/06/2009 |  | Ikea10/06/2009Ikea04/06/2002 | Office Max1 | Office Max | 2009-11-14 00:00:00
 |  |  |  | Office Max12/11/2007 | Office Max12/11/2007Office Max14/11/2009Ikea08/02/2004 |  | Ikea08/04/2008 |  | Ikea28/01/2007 |  | Ikea02/06/2009 |  | Ikea10/06/2009Ikea04/06/2002 | Office Max2 | Office Max | 2007-11-12 00:00:00
 |  |  |  |  | Office Max12/11/2007Office Max14/11/2009Ikea08/02/2004 |  | Ikea08/04/2008 | Office Max08/12/2007 | Office Max08/12/2007Ikea28/01/2007 |  | Ikea02/06/2009 |  | Ikea10/06/2009Ikea04/06/2002 | Office Max3 | Office Max |  |  | 2007-12-08 00:00:00
 |  |  |  |  | Office Max12/11/2007Office Max14/11/2009Ikea08/02/2004 |  | Ikea08/04/2008 |  | Office Max08/12/2007Ikea28/01/2007 | Home Depot14/01/2009 | Home Depot14/01/2009Ikea02/06/2009 |  | Ikea10/06/2009Ikea04/06/2002 | Home Depot1 | Home Depot |  |  |  | 2009-01-14 00:00:00
 |  |  |  |  | Office Max12/11/2007Office Max14/11/2009Ikea08/02/2004 |  | Ikea08/04/2008 | Home Depot15/10/2005 | Home Depot15/10/2005Office Max08/12/2007Ikea28/01/2007 |  | Home Depot14/01/2009Ikea02/06/2009 |  | Ikea10/06/2009Ikea04/06/2002 | Home Depot2 | Home Depot |  |  | 2005-10-15 00:00:00
 |  |  |  | Sears01/09/2008 | Sears01/09/2008Office Max12/11/2007Office Max14/11/2009Ikea08/02/2004 |  | Ikea08/04/2008 |  | Home Depot15/10/2005Office Max08/12/2007Ikea28/01/2007 |  | Home Depot14/01/2009Ikea02/06/2009 |  | Ikea10/06/2009Ikea04/06/2002 | Sears1 | Sears | 2008-09-01 00:00:00
 |  |  |  |  | Sears01/09/2008Office Max12/11/2007Office Max14/11/2009Ikea08/02/2004 |  | Ikea08/04/2008 |  | Home Depot15/10/2005Office Max08/12/2007Ikea28/01/2007 | Sears07/06/2002 | Sears07/06/2002Home Depot14/01/2009Ikea02/06/2009 |  | Ikea10/06/2009Ikea04/06/2002 | Sears2 | Sears |  |  |  | 2002-06-07 00:00:00
 |  |  |  |  | Sears01/09/2008Office Max12/11/2007Office Max14/11/2009Ikea08/02/2004 | Sears14/01/2008 | Sears14/01/2008Ikea08/04/2008 |  | Home Depot15/10/2005Office Max08/12/2007Ikea28/01/2007 |  | Sears07/06/2002Home Depot14/01/2009Ikea02/06/2009 |  | Ikea10/06/2009Ikea04/06/2002 | Sears3 | Sears |  | 2008-01-14 00:00:00
 |  |  |  |  | Sears01/09/2008Office Max12/11/2007Office Max14/11/2009Ikea08/02/2004 |  | Sears14/01/2008Ikea08/04/2008 | Sears08/01/2007 | Sears08/01/2007Home Depot15/10/2005Office Max08/12/2007Ikea28/01/2007 |  | Sears07/06/2002Home Depot14/01/2009Ikea02/06/2009 |  | Ikea10/06/2009Ikea04/06/2002 | Sears4 | Sears |  |  | 2007-01-08 00:00:00
 |  |  |  |  | Sears01/09/2008Office Max12/11/2007Office Max14/11/2009Ikea08/02/2004 | Sears08/09/2007 | Sears08/09/2007Sears14/01/2008Ikea08/04/2008 | Sears10/06/2009 | Sears10/06/2009Sears08/01/2007Home Depot15/10/2005Office Max08/12/2007Ikea28/01/2007 |  | Sears07/06/2002Home Depot14/01/2009Ikea02/06/2009 |  | Ikea10/06/2009Ikea04/06/2002 | Sears5 | Sears |  | 2007-09-08 00:00:00 | 2009-06-10 00:00:00