Removing Dups in same Cell

[chipsworld]

Can anyone help me with this issue?

I have a HUGE report and in most cells in the description column, there are repeated words that I would like to remove.

I have been digging through the web trying to find a way to accomplish this through either VBA or a function and have had no luck.

Here is a small example of what I am talking about... I would like to be able to remove the "MERCEDES-BENZ" repeats but leave the first one. All of the date ranges and Model info I need to keep as well.

Mercedes-Benz 400SE 1992 - 1992/Mercedes-Benz 400SEL 1993 - 1993/Mercedes-Benz 500SEC 1993 - 1993/Mercedes-Benz 500SEL 1992 - 1993/Mercedes-Benz 600SEC 1993 - 1993/Mercedes-Benz 600SEL 1992 - 1993/Mercedes-Benz CL500 1998 - 1999/Mercedes-Benz CL600 1998 - 1999/Mercedes-Benz S320 1994 - 1999/Mercedes-Benz S350D 1993 - 1994/Mercedes-Benz S420 1994 - 1999/Mercedes-Benz S500 1994 - 1999/Mercedes-Benz S600 1994 - 1999

Would do this by hand, but there are 21k+ lines of data to go through.

 

[Akuini]

@chipsworld
1. Do you have a list of the car models?

Some of the models are two words...Toyota Tacoma, Chevy Silverado, etc...

2. How do you know that a model has 1, 2, 3 or more words?

 

[Alex Blakenburg]

If you are interested in pursuing a Power Query, this is my output on your post 9 sample data using the Power Query code at the bottom:

20240410 PQ Concatenate Part of the Field chipsworld.xlsx
	A
1	Result
2	Nissan Pathfinder 1989 - 1995
3	Honda Passport 1994 - 1997/ Isuzu Rodeo 1991 - 1993, 1994 - 1997
4	Mitsubishi Montero 1992 - 2000
5	Acura SLX 1996 - 1997, 1998 - 1999/ Isuzu Trooper 1992 - 1997, 1993 - 1994, 1998 - 2002
6	Ford Bronco Full Size 1988 - 1991, 1992 - 1996
7	Chevy Blazer Full Size 1992 - 1994/ Chevy Tahoe 1995 - 1999/ GMC Yukon 1992 - 1997
Table1

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Added Index" = Table.AddIndexColumn(Source, "Index", 1, 1, Int64.Type),
    #"Split Column by Delimiter" = Table.ExpandListColumn(Table.TransformColumns(#"Added Index", {{"Cars", Splitter.SplitTextByDelimiter("/ ", QuoteStyle.Csv), let itemType = (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "Cars"),
    #"Split Column by Character Transition1" = Table.SplitColumn(#"Split Column by Delimiter", "Cars", Splitter.SplitTextByCharacterTransition((c) => not List.Contains({"0".."9"}, c), {"0".."9"}), {"Cars.1", "Cars.2", "Cars.3"}),
    #"Merged Columns1" = Table.CombineColumns(#"Split Column by Character Transition1",{"Cars.2", "Cars.3"},Combiner.CombineTextByDelimiter("", QuoteStyle.None),"Merged"),
    #"Renamed Columns" = Table.RenameColumns(#"Merged Columns1",{{"Merged", "Years"}}),
    #"Grouped Rows" = Table.Group(#"Renamed Columns", {"Index", "Cars.1"}, {{"Concatenate Years", each Text.Combine([Years], ", "), type text}}),
    #"Inserted Merged Column" = Table.AddColumn(#"Grouped Rows", "Merged", each Text.Combine({[Cars.1], [Concatenate Years]}, " "), type text),
    #"Removed Columns1" = Table.RemoveColumns(#"Inserted Merged Column",{"Cars.1", "Concatenate Years"}),
    #"Grouped Rows1" = Table.Group(#"Removed Columns1", {"Index"}, {{"Result", each Text.Combine([Merged],"/ "), type text}}),
    #"Removed Columns2" = Table.RemoveColumns(#"Grouped Rows1",{"Index"})
in
    #"Removed Columns2"

Note: Cars with a number in the model name might be an issue with this version so I would probably have to slightly amend the above method used for stripping out the year component.

 

[JGordon11]

Another power query approach

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    lst = Table.AddColumn(Source, "x", each List.Transform(Text.Split([Cars],"/"), (x)=> Text.Split(Text.Trim(x)," ") ))[x],
    MatchN = (lst1 as list, lst2 as list)=> 
            List.Last(List.Generate(()=>[match = true, n = 0], each [match], each [match = lst1{[n]} = lst2{[n]}, n = [n] + 1]))[n],
    lst1 = List.Transform(lst, each List.Zip({_, {-1..List.Count(_)-2}})),
    lst2 = List.Transform(lst1, each List.Transform(_, (x)=> if x{1} > -1 then  List.Skip(x{0}, MatchN(x{0}, _{x{1}}{0})) else x{0})),
    lst3 = List.Transform(lst2, each List.Transform(_, (x)=> Text.Combine(x, " "))),
    lst4 = List.Transform(lst3, each Text.Combine(_, ", ")),
    Result = Table.FromColumns({lst4},{"Cars"})
in
    Result

Book2 (version 1).xlsb
	A	B
1	Table1
2	Cars
3	Nissan Pathfinder 1989 - 1995
4	Honda Passport 1994 - 1997/ Isuzu Rodeo 1991 - 1993/ Isuzu Rodeo 1994 - 1997
5	Mitsubishi Montero 1992 - 2000
6	Acura SLX 1996 - 1997/ Acura SLX 1998 - 1999/ Isuzu Trooper 1992 - 1997/ Isuzu Trooper 1993 - 1994/ Isuzu Trooper 1998 - 2002
7	Ford Bronco Full Size 1988 - 1991/ Ford Bronco Full Size 1992 - 1996
8	Chevy Blazer Full Size 1992 - 1994/ Chevy Tahoe 1995 - 1999/ GMC Yukon 1992 - 1997
9	Mercedes-Benz 400SE 1992 - 1992/Mercedes-Benz 400SEL 1993 - 1993/Mercedes-Benz 500SEC 1993 - 1993/Mercedes-Benz 500SEL 1992 - 1993/Mercedes-Benz 600SEC 1993 - 1993/Mercedes-Benz 600SEL 1992 - 1993/Mercedes-Benz CL500 1998 - 1999/Mercedes-Benz CL600 1998 - 1999/Mercedes-Benz S320 1994 - 1999/Mercedes-Benz S350D 1993 - 1994/Mercedes-Benz S420 1994 - 1999/Mercedes-Benz S500 1994 - 1999/Mercedes-Benz S600 1994 - 1999
10
11	Query Output
12	Cars
13	Nissan Pathfinder 1989 - 1995
14	Honda Passport 1994 - 1997, Isuzu Rodeo 1991 - 1993, 1994 - 1997
15	Mitsubishi Montero 1992 - 2000
16	Acura SLX 1996 - 1997, 1998 - 1999, Isuzu Trooper 1992 - 1997, 1993 - 1994, 1998 - 2002
17	Ford Bronco Full Size 1988 - 1991, 1992 - 1996
18	Chevy Blazer Full Size 1992 - 1994, Tahoe 1995 - 1999, GMC Yukon 1992 - 1997
19	Mercedes-Benz 400SE 1992 - 1992, 400SEL 1993 - 1993, 500SEC 1993 - 1993, 500SEL 1992 - 1993, 600SEC 1993 - 1993, 600SEL 1992 - 1993, CL500 1998 - 1999, CL600 1998 - 1999, S320 1994 - 1999, S350D 1993 - 1994, S420 1994 - 1999, S500 1994 - 1999, S600 1994 - 1999
20
Sheet1

 

[chipsworld]

I thank all of you for your help. I am not familiar with Power Query yet, so not sure if that is a viable option to date. I am going to try to learn it now though as it seems that it would be a great helper tool going forward.

I am uploading a minisheet of what I am working with.

As you can see, COl A has the part number shown multiple times. THe original source is from outside the porg, and I have no control over how they provide their data. THerefore I am trying to find a workaround.

I have a solution to collect all of the data for each PT# and put it into a single cells, but then I need to clean it up.

If someone can dev a single source code to do both, that would be awesome, but if not, I just need to be able to clean it up.

Alamo Auto Full Parts File 04.08.24_Orig.xlsx
	B	C	D	E	F	G	H	I	J
1	Part	Color	Product Group	Make	Model	Make/Model	Year	Fit Notes
2	36014	Black	TechLiner	Toyota	Tacoma	Toyota Tacoma	2016 - 2023	Fits 60.3" beds	Toyota Tacoma 2016 - 2023
3	36014	Black	TechLiner	Toyota	Tacoma	Toyota Tacoma	2005 - 2015	Fits 60.3" beds	Toyota Tacoma 2016 - 2023/Toyota Tacoma 2005 - 2015
4	36016	Black	TechLiner	Ford	Ranger	Ford Ranger	2019 - 2020	Bed Liner only, Does not include Tailgate Liner	Ford Ranger 2019 - 2020
5	36603	Black	TechLiner	Ford	F-150	Ford F-150	2011 - 2014	5' 5" box	Ford F-150 2011 - 2014
6	36603	Black	TechLiner	Ford	F-150	Ford F-150	2011 - 2014	5' 6"	Ford F-150 2011 - 2014/Ford F-150 2011 - 2014
7	36611	Black	TechLiner	Toyota	Tundra	Toyota Tundra	2007 - 2019	Fits 5' 6" bed	Toyota Tundra 2007 - 2019
8	36706	Black	TechLiner	Dodge	Ram Truck 1500 Classic	Dodge Ram Truck 1500 Classic	2019 - 2023	6' 4", Bed Liner only, Does not include Tailgate Liner	Dodge Ram Truck 1500 Classic 2019 - 2023
9	36706	Black	TechLiner	Dodge	Ram Truck 2500/3500	Dodge Ram Truck 2500/3500	2010 - 2018	6' 4", Bed Liner only, Does not include Tailgate Liner	Dodge Ram Truck 1500 Classic 2019 - 2023/Dodge Ram Truck 2500/3500 2010 - 2018
10	36706	Black	TechLiner	Dodge	Ram Truck 2500/3500	Dodge Ram Truck 2500/3500	2019 - 2024	6' 4", Bed Liner only, Does not include Tailgate Liner	Dodge Ram Truck 1500 Classic 2019 - 2023/Dodge Ram Truck 2500/3500 2010 - 2018/Dodge Ram Truck 2500/3500 2019 - 2024
11	36706	Black	TechLiner	Dodge	Ram Trucl 1500	Dodge Ram Trucl 1500	2009 - 2018	6' 4", Bed Liner only, Does not include Tailgate Liner	Dodge Ram Truck 1500 Classic 2019 - 2023/Dodge Ram Truck 2500/3500 2010 - 2018/Dodge Ram Truck 2500/3500 2019 - 2024/Dodge Ram Trucl 1500 2009 - 2018
12	36706	Black	TechLiner	RAM	Ram 1500	RAM Ram 1500	2009 - 2018	6' 4", Bed Liner only, Does not include Tailgate Liner	Dodge Ram Truck 1500 Classic 2019 - 2023/Dodge Ram Truck 2500/3500 2010 - 2018/Dodge Ram Truck 2500/3500 2019 - 2024/Dodge Ram Trucl 1500 2009 - 2018/RAM Ram 1500 2009 - 2018
13	36706	Black	TechLiner	RAM	Ram 1500 Classic	RAM Ram 1500 Classic	2019 - 2020	6' 4", Bed Liner only, Does not include Tailgate Liner	Dodge Ram Truck 1500 Classic 2019 - 2023/Dodge Ram Truck 2500/3500 2010 - 2018/Dodge Ram Truck 2500/3500 2019 - 2024/Dodge Ram Trucl 1500 2009 - 2018/RAM Ram 1500 2009 - 2018/RAM Ram 1500 Classic 2019 - 2020
14	36706	Black	TechLiner	RAM	Ram 2500/3500	RAM Ram 2500/3500	2019 - 2024	6' 4", Bed Liner only, Does not include Tailgate Liner	Dodge Ram Truck 1500 Classic 2019 - 2023/Dodge Ram Truck 2500/3500 2010 - 2018/Dodge Ram Truck 2500/3500 2019 - 2024/Dodge Ram Trucl 1500 2009 - 2018/RAM Ram 1500 2009 - 2018/RAM Ram 1500 Classic 2019 - 2020/RAM Ram 2500/3500 2019 - 2024
15	36706	Black	TechLiner	RAM	Ram 2500/3500	RAM Ram 2500/3500	2010 - 2018	6' 4", Bed Liner only, Does not include Tailgate Liner	Dodge Ram Truck 1500 Classic 2019 - 2023/Dodge Ram Truck 2500/3500 2010 - 2018/Dodge Ram Truck 2500/3500 2019 - 2024/Dodge Ram Trucl 1500 2009 - 2018/RAM Ram 1500 2009 - 2018/RAM Ram 1500 Classic 2019 - 2020/RAM Ram 2500/3500 2019 - 2024/RAM Ram 2500/3500 2010 - 2018
16	36905	Black	TechLiner	Chevrolet	Silverado	Chevrolet Silverado	2007 - 2013	Short 5' 9.25"	Chevrolet Silverado 2007 - 2013
17	36905	Black	TechLiner	Chevrolet	Silverado 1500	Chevrolet Silverado 1500	2014 - 2018	Short 5' 9.25"	Chevrolet Silverado 2007 - 2013/Chevrolet Silverado 1500 2014 - 2018
18	36905	Black	TechLiner	Chevrolet	Silverado 2500/3500	Chevrolet Silverado 2500/3500	2015 - 2019	Short 5' 9.25"	Chevrolet Silverado 2007 - 2013/Chevrolet Silverado 1500 2014 - 2018/Chevrolet Silverado 2500/3500 2015 - 2019
19	36905	Black	TechLiner	GMC	Sierra	GMC Sierra	2007 - 2013	Short 5' 9.25"	Chevrolet Silverado 2007 - 2013/Chevrolet Silverado 1500 2014 - 2018/Chevrolet Silverado 2500/3500 2015 - 2019/GMC Sierra 2007 - 2013
20	36905	Black	TechLiner	GMC	Sierra / Sierra Denali 1500	GMC Sierra / Sierra Denali 1500	2014 - 2018	Short 5' 9.25"	Chevrolet Silverado 2007 - 2013/Chevrolet Silverado 1500 2014 - 2018/Chevrolet Silverado 2500/3500 2015 - 2019/GMC Sierra 2007 - 2013/GMC Sierra / Sierra Denali 1500 2014 - 2018
21	36905	Black	TechLiner	GMC	Sierra / Sierra Denali 1500	GMC Sierra / Sierra Denali 1500	2014 - 2018	Short 5' 9.25", Bed Liner Only, Does not include Tailgate Liner	Chevrolet Silverado 2007 - 2013/Chevrolet Silverado 1500 2014 - 2018/Chevrolet Silverado 2500/3500 2015 - 2019/GMC Sierra 2007 - 2013/GMC Sierra / Sierra Denali 1500 2014 - 2018/GMC Sierra / Sierra Denali 1500 2014 - 2018
22	36914	Black	TechLiner	Chevrolet	Colorado	Chevrolet Colorado	2015 - 2022	Short Bed	Chevrolet Colorado 2015 - 2022
23	36914	Black	TechLiner	GMC	Canyon	GMC Canyon	2015 - 2022	Short Bed, Bed Liner Only, Does not include Tailgate Liner	Chevrolet Colorado 2015 - 2022/GMC Canyon 2015 - 2022
24	36920	Black	TechLiner	Toyota	Tundra	Toyota Tundra	2022 - 2024	CrewMax, 5.5' Bed Designated trim required for access to bed cover drains at front of truck bed, 5.5' bed is only available in CrewMax Config. For 2022	Toyota Tundra 2022 - 2024
25	36920	Black	TechLiner	Toyota	Tundra Hybrid	Toyota Tundra Hybrid	2022 - 2024	5.5'Bed, Hybrid Models only offered as a CrewMax, Designated trim required for access to bed cover drains at front of truck bed.	Toyota Tundra 2022 - 2024/Toyota Tundra Hybrid 2022 - 2024
26	36920	Black	TechLiner	Toyota	Tundra	Toyota Tundra	2022 - 2024	Bed Liner Only, Does not include Tailgate Liner, optional trm limes available for access to bed cover drains at front of truck bed	Toyota Tundra 2022 - 2024/Toyota Tundra Hybrid 2022 - 2024/Toyota Tundra 2022 - 2024
27	36920	Black	TechLiner	Toyota	Tundra Hybrid	Toyota Tundra Hybrid	2022 - 2024	Bed Liner Only, Does not include Tailgate Liner, optional trm limes available for access to bed cover drains at front of truck bed	Toyota Tundra 2022 - 2024/Toyota Tundra Hybrid 2022 - 2024/Toyota Tundra 2022 - 2024/Toyota Tundra Hybrid 2022 - 2024
From Rene

THe below is what I end up with after my original manipulations... THis is where I am stuck. Trying to clean up col E to get rid of dups.

Example.xlsx
	A	B	C	D	E
1	Make	Model	Make/Model	Year	Desc Long
2	Toyota	Tacoma	Toyota Tacoma	2005 - 2015	Toyota Tacoma 2016 - 2023/ 2005 - 2015
3	Ford	Ranger	Ford Ranger	2019 - 2020	Ford Ranger 2019 - 2020
4	Ford	F-150	Ford F-150	2011 - 2014	Ford F-150 2011 - 2014/ Ford F-150 2011 - 2014
5	Toyota	Tundra	Toyota Tundra	2007 - 2019	Toyota Tundra 2007 - 2019
6	JKS	Ram 2500/3500	RAM Ram 2500/3500	2010 - 2018	Dodge Ram 1500 Classic 2019 - 2023/ Dodge Ram 2500/ 3500 2010 - 2018/ Dodge Ram 2500/ 3500 2019 - 2024/ Dodge Ram 1500 2009 - 2018/ Ram 1500 2009 - 2018/ Ram 1500 Classic 2019 - 2020/ Ram 2500/ 3500 2019 - 2024/ Ram 2500/ 3500 2010 - 2018
7	GMC	Sierra / Sierra Denali 1500	GMC Sierra / Sierra Denali 1500	2014 - 2018	Chevy Silverado 2007 - 2013/ Chevy Silverado 1500 2014 - 2018/ Chevy Silverado 2500/ 3500 2015 - 2019/ GMC Sierra 2007 - 2013/ GMC Sierra / Sierra Denali 1500 2014 - 2018/ GMC Sierra / Sierra Denali 1500 2014 - 2018
8	GMC	Canyon	GMC Canyon	2015 - 2022	Chevy Colorado 2015 - 2022/ GMC Canyon 2015 - 2022
9	Toyota	Tundra Hybrid	Toyota Tundra Hybrid	2022 - 2024	Toyota Tundra 2022 - 2024/ Toyota Tundra Hybrid 2022 - 2024/ Toyota Tundra 2022 - 2024/ Toyota Tundra Hybrid 2022 - 2024
10	Toyota	Tacoma	Toyota Tacoma	2016 - 2020	Toyota Tacoma 2005 - 2023/ Toyota Tacoma 2016 - 2020
11	GMC	Canyon	GMC Canyon	2015 - 2022	Chevy Colorado 2015 - 2022/ GMC Canyon 2015 - 2022
12	Ram	Ram 1500	Ram Ram 1500	2019 - 2024	Dodge Ram 1500 2019 - 2024/ Ram 1500 2019 - 2024
13	RAM	Ram 1500 Classic	RAM Ram 1500 Classic	2009 - 2023	Dodge Ram 1500 2009 - 2018/ Dodge Ram 1500 Classic 2009 - 2023/ Ram 1500 2009 - 2018/ Ram 1500 Classic 2009 - 2023
14	Ford	F-150	Ford F-150	2011 - 2014	Ford F-150 2004 - 2012/ Ford F-150 2011 - 2014
15	GMC	Sierra / Sierra Denali 2500/3500	GMC Sierra / Sierra Denali 2500/3500	2015 - 2019	Chevy Silverado 2007 - 2012/ Chevy Silverado 1500 2014 - 2018/ Chevy Silverado 2500/ 3500 2015 - 2019/ GMC Sierra 2007 - 2012/ GMC Sierra / Sierra Denali 1500 2014 - 2018/ GMC Sierra / Sierra Denali 2500/ 3500 2015 - 2019
16	Toyota	Tundra	Toyota Tundra	2007 - 2019	Toyota Tundra 2007 - 2019
17	Ford	F-250/F-350/F-450/F-550	Ford F-250/F-350/F-450/F-550	2009 - 2016	Ford F-250/ F-350/ F-450/ F-550 2009 - 2016
18	Ford	F-250/F-350/F-450/F-550	Ford F-250/F-350/F-450/F-550	2023 - 2024	Ford F-250/ F-350/ F-450/ F-550 2017 - 2022/ Ford F-250/ F-350/ F-450/ F-550 2023 - 2024
19	Ford	F-250/F-350/F-450/F-552	Ford F-250/F-350/F-450/F-552	2009 - 2016	Ford F-250/ F-350/ F-450/ F-551 2009 - 2012/ Ford F-250/ F-350/ F-450/ F-552 2009 - 2016
20	Ford	F-150	Ford F-150	2011 - 2014	Ford F-150 2011 - 2014
21	Ford	F-150	Ford F-150	2021 - 2023	Ford F-150 2015 - 2020/ Ford F-150 2021 - 2023
22	Ford	F-250/F-350/F-450/F-550	Ford F-250/F-350/F-450/F-550	2023	Ford F-250/ F-350/ F-450/ F-550 2017 - 2022/ Ford F-250/ F-350/ F-450/ F-550 2023
23	RAM	Ram 2500/3500	RAM Ram 2500/3500	2019 - 2024	Dodge Ram 1500 2009 - 2018/ Dodge Ram 1500 Classic 2019 - 2023/ Dodge Ram 2500/ 3500 2010 - 2018/ Dodge Ram 2500/ 3500 2019 - 2024/ Ram 1500 2009 - 2018/ Ram 1500 Classic 2019 - 2023/ Ram 2500/ 3500 2010 - 2018/ Ram 2500/ 3500 2019 - 2024
24	GMC	Sierra / Sierra Denali 2500/3500	GMC Sierra / Sierra Denali 2500/3500	2015 - 2019	Chevy Silverado 2007 - 2013/ Chevy Silverado 1500 2014 - 2018/ Chevy Silverado 2500/ 3500 2015 - 2019/ GMC Sierra 2007 - 2013/ GMC Sierra / Sierra Denali 1500 2014 - 2018/ GMC Sierra / Sierra Denali 2500/ 3500 2015 - 2019
25	Toyota	Tundra	Toyota Tundra	2007 - 2019	Toyota Tundra 2007 - 2019
26	GMC	Sierra / Sierra Denali 1500	GMC Sierra / Sierra Denali 1500	2019 - 2024	Chevy Silverado 1500 2019 - 2024/ GMC Sierra / Sierra Denali 1500 2019 - 2024
27	GMC	Sierra / Sierra Denali 2500HD / 3500HD	GMC Sierra / Sierra Denali 2500HD / 3500HD	2020 - 2024	Chevy Silverado 2500HD/ 3500HD 2020 - 2024/ Chevy Siverado 2500HD / 3500HD 2020 - 2024/ GMC Sierra / Sierra Denali 2500 HD / 3500HD 2020 - 2024/ GMC Sierra / Sierra Denali 2500HD / 3500HD 2020 - 2024
28	Ford	Ranger	Ford Ranger	2019 - 2023	Ford Ranger 2019 - 2023
29	Mercury	Mountaineer	Mercury Mountaineer	1997 - 2001	Ford Explorer 1991 - 1994/ Ford Explorer 1995 - 2001/ Mercury Mountaineer 1997 - 2001
30	Mazda	0vajo (2 door)	Mazda 0vajo (2 door)	1991 - 1994	Ford Explorer Sport 1991 - 1994/ Ford Explorer Sport 1995 - 2000/ Ford Explorer Sport 2001 - 2003/ Mazda 0vajo (2 door) 1991 - 1994
31	Jeep	Cherokee (4 door)	Jeep Cherokee (4 door)	1997 - 2001	Jeep Cherokee (2 door) 1984 - 1996/ Jeep Cherokee (2 door) 1997 - 2001/ Jeep Cherokee (4 door) 1984 - 1996/ Jeep Cherokee (4 door) 1997 - 2001
32	Jeep	Grand Cherokee	Jeep Grand Cherokee	1993 - 1998	Jeep Grand Cherokee 1993 - 1998
33	Chevrolet	Suburban	Chevrolet Suburban	1992 - 1999	Chevy Suburban 1992 - 1999
Consolidated

I appreciate anything you can do. CUBIST has given me a tool that does help and I can work with it, but if there is a better solution, I would be thrilled to have it.