Consolidating multiple cells into one

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!
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
So you want your output for Part# 111000 to look like this in columns (not rows as shown and without the titles ie. Year range)?
Year Range 1997-2014; 2018-2018; etc; 1994-2004
Make Ford; Ram; Ram; etc; Chevrolet
Model F-150; Ram; Ram; etc; Silverado
Style All; Laramee; All; etc.; 2500 All
Doesn't seem very readable/useable like this and U may exceed the 255 cell character limit. Maybe a bit more info. Dave
 
Upvote 0
Yes ideally there would be a carriage return between each cells entry. But i agree there are going to be times where i hit the cell character limit.
 
Upvote 0
So if there's a possibility of exceeding the character limit then it's best to take a different approach. I think what U really are trying to do is reduce your search time for part# information??? Maybe have a userform that U enter the part# into a textbox and it outputs all of the yr range, make ,model and style information for the part number in separate listboxes or in a consolidated display of some kind. Maybe some more info on what's the purpose and how U want to proceed. Dave
 
Upvote 0

Forum statistics

Threads
1,223,903
Messages
6,175,284
Members
452,630
Latest member
OdubiYouth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top