michellejames
New Member
- Joined
- Aug 16, 2013
- Messages
- 27
Hi There,
Greeting! We would like combine year for each same make and mode for each sku. I have try short, subtotal. But still not reach the result. Please check my excel of output tab and suggest me some formula or macro.
<colgroup><col><col span="2"><col></colgroup><tbody>
</tbody>
Output
<colgroup><col><col span="2"><col><col><col span="2"></colgroup><tbody>
</tbody>
https://files.fm/u/95ez8cxr
Regards,
Greeting! We would like combine year for each same make and mode for each sku. I have try short, subtotal. But still not reach the result. Please check my excel of output tab and suggest me some formula or macro.
sku | year | make | model |
100747900A00PG | 2012 | Tesla | S |
100747900A00PG | 2013 | Tesla | S |
100747900A00PG | 2014 | Tesla | S |
100747900A00PG | 2015 | Tesla | S |
100747900A00PG | 2016 | Tesla | S |
26300-35503 | 2008 | Hyundai | Accent |
26300-35503 | 2009 | Hyundai | Accent |
26300-35503 | 2010 | Hyundai | Accent |
26300-35503 | 2011 | Hyundai | Accent |
26300-35503 | 2012 | Hyundai | Accent |
26300-35503 | 2013 | Hyundai | Accent |
26300-35503 | 2014 | Hyundai | Accent |
26300-35503 | 2015 | Hyundai | Accent |
26300-35503 | 2016 | Hyundai | Accent |
26300-35503 | 2017 | Hyundai | XYZ |
26300-35503 | 2008 | Hyundai | Elantra |
26300-35503 | 2009 | Hyundai | Elantra |
26300-35503 | 2010 | Hyundai | Elantra |
26300-35503 | 2011 | Hyundai | Elantra |
26300-35503 | 2012 | Hyundai | Elantra |
26300-35503 | 2013 | Hyundai | Elantra |
26300-35503 | 2014 | Hyundai | Elantra |
26300-35503 | 2015 | Hyundai | Elantra |
26300-35503 | 2013 | Hyundai | Elantra Coupe |
26300-35503 | 2014 | Hyundai | Elantra Coupe |
26300-35503 | 2013 | Hyundai | Elantra GT |
26300-35503 | 2014 | Hyundai | Elantra GT |
26300-35503 | 2015 | Hyundai | Elantra GT |
26300-35503 | 2016 | Hyundai | Elantra GT |
26300-35503 | 2013 | Hyundai | Genesis Coupe |
26300-35503 | 2014 | Hyundai | Genesis Coupe |
26300-35503 | 2017 | Hyundai | Ioniq |
26300-35503 | 2018 | Hyundai | Ioniq |
26300-35503 | 2018 | Kia | Forte5 |
26300-35503 | 2008 | Kia | Magentis |
26300-35503 | 2009 | Kia | Magentis |
26300-35503 | 2010 | Kia | Magentis |
26300-35503 | 2017 | Kia | Niro |
26300-35503 | 2018 | Kia | Niro |
A44690 | 2004 | Cadillac | SRX |
A44690 | 2005 | Cadillac | SRX |
A44690 | 2006 | Cadillac | SRX |
A44690 | 2007 | Cadillac | SRX |
A44690 | 2008 | Cadillac | SRX |
A44690 | 2009 | Cadillac | SRX |
A44690 | 2005 | Cadillac | STS |
A44690 | 2006 | Cadillac | STS |
A44690 | 2007 | Cadillac | STS |
A44690 | 2008 | Cadillac | STS |
B16 | 1970 | Ford | Custom |
B16 | 1971 | Ford | Custom |
B16 | 1972 | Ford | Custom |
B16 | 1972 | Ford | Custom 500 |
B16 | 1973 | Ford | Custom 500 |
B3127 | 1986 | Ford | E-350 Econoline |
B3127 | 1987 | Ford | E-350 Econoline |
B3127 | 1978 | Ford | E-350 Econoline Club Wagon |
B3127 | 1979 | Ford | E-350 Econoline Club Wagon |
B3127 | 1986 | Ford | F-350 |
B3127 | 1987 | Ford | F-350 |
B3127 | 1978 | Ford | Fairmont |
B3127 | 1979 | Ford | Fairmont |
B3127 | 1980 | Ford | Fairmont |
B3127 | 1981 | Ford | Fairmont |
B3127 | 1982 | Ford | Fairmont |
B3127 | 1978 | Ford | Granada |
B3127 | 1979 | Ford | Granada |
B3127 | 1980 | Ford | Granada |
B3127 | 1981 | Ford | Granada |
B3127 | 1978 | Ford | LTD |
B3127 | 1987 | Ford | LTD Crown Victoria |
B3127 | 1988 | Ford | LTD Crown Victoria |
B3127 | 1989 | Ford | LTD Crown Victoria |
B3127 | 1978 | Ford | LTD II |
B3127 | 1979 | Ford | LTD II |
B3127 | 1979 | Ford | Mustang |
B3127 | 1980 | Ford | Mustang |
B3127 | 1981 | Ford | Mustang |
B3127 | 1982 | Ford | Mustang |
B3127 | 1978 | Ford | Mustang II |
B3127 | 1978 | Ford | Ranchero |
B3127 | 1979 | Ford | Ranchero |
B3127 | 1978 | Ford | Thunderbird |
B3127 | 1979 | Ford | Thunderbird |
<colgroup><col><col span="2"><col></colgroup><tbody>
</tbody>
Output
sku | year | make | model | Combine year | make | model |
100747900A00PG | 2012 | Tesla | S | 2012-2016 | Tesla | S |
100747900A00PG | 2013 | Tesla | S | |||
100747900A00PG | 2014 | Tesla | S | |||
100747900A00PG | 2015 | Tesla | S | |||
100747900A00PG | 2016 | Tesla | S | |||
26300-35503 | 2008 | Hyundai | Accent | 2008 -2016 | Hyundai | Accent |
26300-35503 | 2009 | Hyundai | Accent | |||
26300-35503 | 2010 | Hyundai | Accent | |||
26300-35503 | 2011 | Hyundai | Accent | |||
26300-35503 | 2012 | Hyundai | Accent | |||
26300-35503 | 2013 | Hyundai | Accent | |||
26300-35503 | 2014 | Hyundai | Accent | |||
26300-35503 | 2015 | Hyundai | Accent | |||
26300-35503 | 2016 | Hyundai | Accent | |||
26300-35503 | 2017 | Hyundai | XYZ | 2017 | Hyundai | XYZ |
26300-35503 | 2008 | Hyundai | Elantra | 2008-2015 | Hyundai | Elantra |
26300-35503 | 2009 | Hyundai | Elantra | |||
26300-35503 | 2010 | Hyundai | Elantra | |||
26300-35503 | 2011 | Hyundai | Elantra | |||
26300-35503 | 2012 | Hyundai | Elantra | |||
26300-35503 | 2013 | Hyundai | Elantra | |||
26300-35503 | 2014 | Hyundai | Elantra | |||
26300-35503 | 2015 | Hyundai | Elantra | |||
26300-35503 | 2013 | Hyundai | Elantra Coupe | 2013-2014 | Hyundai | Elantra Coupe |
26300-35503 | 2014 | Hyundai | Elantra Coupe | |||
26300-35503 | 2013 | Hyundai | Elantra GT | 2013-2016 | Hyundai | Elantra GT |
26300-35503 | 2014 | Hyundai | Elantra GT | |||
26300-35503 | 2015 | Hyundai | Elantra GT | |||
26300-35503 | 2016 | Hyundai | Elantra GT | |||
26300-35503 | 2013 | Hyundai | Genesis Coupe | 2013-2014 | Hyundai | Genesis Coupe |
26300-35503 | 2014 | Hyundai | Genesis Coupe | |||
26300-35503 | 2017 | Hyundai | Ioniq | 2017-2018 | Hyundai | Ioniq |
26300-35503 | 2018 | Hyundai | Ioniq | |||
26300-35503 | 2018 | Kia | Forte5 | 2018 | Kia | Forte5 |
26300-35503 | 2008 | Kia | Magentis | 2008-2010 | Kia | Magentis |
26300-35503 | 2009 | Kia | Magentis | |||
26300-35503 | 2010 | Kia | Magentis | |||
26300-35503 | 2017 | Kia | Niro | 2017-2018 | Kia | Niro |
26300-35503 | 2018 | Kia | Niro | |||
A44690 | 2004 | Cadillac | SRX | 2004-2009 | Cadillac | SRX |
A44690 | 2005 | Cadillac | SRX | |||
A44690 | 2006 | Cadillac | SRX | |||
A44690 | 2007 | Cadillac | SRX | |||
A44690 | 2008 | Cadillac | SRX | |||
A44690 | 2009 | Cadillac | SRX | |||
A44690 | 2005 | Cadillac | STS | 2005-2008 | Cadillac | STS |
A44690 | 2006 | Cadillac | STS | |||
A44690 | 2007 | Cadillac | STS | |||
A44690 | 2008 | Cadillac | STS | |||
B16 | 1970 | Ford | Custom | 1970-1972 | Ford | Custom |
B16 | 1971 | Ford | Custom | |||
B16 | 1972 | Ford | Custom | |||
B16 | 1972 | Ford | Custom 500 | 1972-1973 | Ford | Custom 500 |
B16 | 1973 | Ford | Custom 500 | |||
B3127 | 1986 | Ford | E-350 Econoline | 1986-1987 | Ford | E-350 Econoline |
B3127 | 1987 | Ford | E-350 Econoline | |||
B3127 | 1978 | Ford | E-350 Econoline Club Wagon | 1978-1979 | Ford | E-350 Econoline Club Wagon |
B3127 | 1979 | Ford | E-350 Econoline Club Wagon | |||
B3127 | 1986 | Ford | F-350 | 1986-1987 | Ford | F-350 |
B3127 | 1987 | Ford | F-350 | |||
B3127 | 1978 | Ford | Fairmont | 1978-1982 | Ford | Fairmont |
B3127 | 1979 | Ford | Fairmont | |||
B3127 | 1980 | Ford | Fairmont | |||
B3127 | 1981 | Ford | Fairmont | |||
B3127 | 1982 | Ford | Fairmont | |||
B3127 | 1978 | Ford | Granada | 1978-1981 | Ford | Granada |
B3127 | 1979 | Ford | Granada | |||
B3127 | 1980 | Ford | Granada | |||
B3127 | 1981 | Ford | Granada | |||
B3127 | 1978 | Ford | LTD | 1978 | Ford | LTD |
B3127 | 1987 | Ford | LTD Crown Victoria | 1987-1989 | Ford | LTD Crown Victoria |
B3127 | 1988 | Ford | LTD Crown Victoria | |||
B3127 | 1989 | Ford | LTD Crown Victoria | |||
B3127 | 1978 | Ford | LTD II | 1978-1979 | Ford | LTD II |
B3127 | 1979 | Ford | LTD II | |||
B3127 | 1979 | Ford | Mustang | 1979-1982 | Ford | Mustang |
B3127 | 1980 | Ford | Mustang | |||
B3127 | 1981 | Ford | Mustang | |||
B3127 | 1982 | Ford | Mustang | |||
B3127 | 1978 | Ford | Mustang II | 1978 | Ford | Mustang II |
B3127 | 1978 | Ford | Ranchero | 1978-1979 | Ford | Ranchero |
B3127 | 1979 | Ford | Ranchero | |||
B3127 | 1978 | Ford | Thunderbird | 1978-1979 | Ford | Thunderbird |
B3127 | 1979 | Ford | Thunderbird |
<colgroup><col><col span="2"><col><col><col span="2"></colgroup><tbody>
</tbody>
https://files.fm/u/95ez8cxr
Regards,