Cranman2127
New Member
- Joined
- Sep 2, 2016
- Messages
- 36
Hello,
I'm trying to make a macro or formula to group data from multiple cells into one based on if a part number is the same.
There are five columns of data:
Part#
Year Range
Make
Model
Style
Essentially what I need to do is if a part number repeats then all the year ranges will be consolidated into the first row the part number shows up on. Same goes for Make, Model, and Style.
The number of times a part number repeats isn't static.
Example data below:
Part # Year Range Make Model Style
1042 1995-1998 Jeep Grand Cherokee TOW HOOK ONLY (4WD ONLY)
1043 1986-2000 Jeep Cherokee EXCLUDING LIMITED
1043 1986-2000 Jeep Sport EXCLUDING LIMITED
1044 1999-2004 Jeep Grand Cherokee TOW HOOK ONLY
1045 2002-2004 Jeep Liberty EXCLUDING RENEGADE
1046 2005-2010 Jeep Grand Cherokee ALL
1047 2005-2007 Jeep Liberty ALL
1048 2006-2010 Jeep Commander ALL
1050 2007-2015 Jeep Wrangler EXCLUDE RUBICON HARD ROCK (NO HEADLIGHT CAGE)
1051 2008-2012 Jeep Liberty NO HEADLIGHT CAGE
1052 2016-2016 Jeep Grand Cherokee 75th Anniversary without Active Cruise Control
1052 2011-2018 Jeep Grand Cherokee Limited without Active Cruise Control
1052 2011-2018 Jeep Grand Cherokee Laredo without Active Cruise Control
1052 2011-2018 Jeep Grand Cherokee Overland without Active Cruise Control
111000 1997-2014 Ford F-150 ALL
111000 2018-2018 Ram 1500 Laramie
111000 2011-2017 Ram 2500 ALL
111000 2018-2018 Ram 1500 Limited
111000 2018-2018 Ram 1500 Tradesman
111000 1988-2000 Chevrolet C2500 ALL
111000 2005-2006 Chevrolet Silverado 1500 HD ALL
111000 2001-2003 GMC Sierra 1500 HD ALL
111000 2018-2018 Ram 3500 Laramie
111000 1988-2000 GMC C3500 ALL
111000 2007-2007 Chevrolet Silverado 1500 Classic ALL
111000 2001-2006 GMC Sierra 3500 ALL
111000 2007-2007 GMC Sierra 1500 HD Classic ALL
111000 2007-2007 Chevrolet Silverado 1500 HD Classic ALL
111000 2007-2007 GMC Sierra 2500 HD Classic ALL
111000 2007-2007 Chevrolet Silverado 2500 HD Classic ALL
111000 2018-2018 Ram 3500 Tradesman
111000 2007-2007 GMC Sierra 1500 Classic ALL
111000 1988-1999 GMC C1500 ALL
111000 1999-2004 GMC Sierra 2500 ALL
111000 2018-2018 Ram 2500 SLT
111000 2018-2018 Ram 2500 Laramie Longhorn
111000 2018-2018 Ram 2500 Power Wagon
111000 2007-2007 GMC Sierra 3500 Classic ALL
111000 1999-2004 Chevrolet Silverado 2500 ALL
Thank you for any help!
I'm trying to make a macro or formula to group data from multiple cells into one based on if a part number is the same.
There are five columns of data:
Part#
Year Range
Make
Model
Style
Essentially what I need to do is if a part number repeats then all the year ranges will be consolidated into the first row the part number shows up on. Same goes for Make, Model, and Style.
The number of times a part number repeats isn't static.
Example data below:
Part # Year Range Make Model Style
1042 1995-1998 Jeep Grand Cherokee TOW HOOK ONLY (4WD ONLY)
1043 1986-2000 Jeep Cherokee EXCLUDING LIMITED
1043 1986-2000 Jeep Sport EXCLUDING LIMITED
1044 1999-2004 Jeep Grand Cherokee TOW HOOK ONLY
1045 2002-2004 Jeep Liberty EXCLUDING RENEGADE
1046 2005-2010 Jeep Grand Cherokee ALL
1047 2005-2007 Jeep Liberty ALL
1048 2006-2010 Jeep Commander ALL
1050 2007-2015 Jeep Wrangler EXCLUDE RUBICON HARD ROCK (NO HEADLIGHT CAGE)
1051 2008-2012 Jeep Liberty NO HEADLIGHT CAGE
1052 2016-2016 Jeep Grand Cherokee 75th Anniversary without Active Cruise Control
1052 2011-2018 Jeep Grand Cherokee Limited without Active Cruise Control
1052 2011-2018 Jeep Grand Cherokee Laredo without Active Cruise Control
1052 2011-2018 Jeep Grand Cherokee Overland without Active Cruise Control
111000 1997-2014 Ford F-150 ALL
111000 2018-2018 Ram 1500 Laramie
111000 2011-2017 Ram 2500 ALL
111000 2018-2018 Ram 1500 Limited
111000 2018-2018 Ram 1500 Tradesman
111000 1988-2000 Chevrolet C2500 ALL
111000 2005-2006 Chevrolet Silverado 1500 HD ALL
111000 2001-2003 GMC Sierra 1500 HD ALL
111000 2018-2018 Ram 3500 Laramie
111000 1988-2000 GMC C3500 ALL
111000 2007-2007 Chevrolet Silverado 1500 Classic ALL
111000 2001-2006 GMC Sierra 3500 ALL
111000 2007-2007 GMC Sierra 1500 HD Classic ALL
111000 2007-2007 Chevrolet Silverado 1500 HD Classic ALL
111000 2007-2007 GMC Sierra 2500 HD Classic ALL
111000 2007-2007 Chevrolet Silverado 2500 HD Classic ALL
111000 2018-2018 Ram 3500 Tradesman
111000 2007-2007 GMC Sierra 1500 Classic ALL
111000 1988-1999 GMC C1500 ALL
111000 1999-2004 GMC Sierra 2500 ALL
111000 2018-2018 Ram 2500 SLT
111000 2018-2018 Ram 2500 Laramie Longhorn
111000 2018-2018 Ram 2500 Power Wagon
111000 2007-2007 GMC Sierra 3500 Classic ALL
111000 1999-2004 Chevrolet Silverado 2500 ALL
Thank you for any help!