I have a spreadsheet that looks like this (and sorry for doing it like this, but MrExcelHTML doesn't work for me any more).
<colgroup span="5" width="128"></colgroup><tbody>
</tbody>
<!-- ************************************************************************** -->
As you see, some entries in the 'technologies' column recur in different rows. What I am looking for is a way to generate a new sheet with every technology mentioned only once, with in the third column an overview of the different media titles, separated with a ; S for instance for battery improvements, the third column would have: CTNSP-2007-Further look at technologies for stabilization operations.pdf; Unravelling the energy tether: new power technologies take aim at the dismounted soldier; Technology Trends SurveyFuture Emerging Technology Trends; 2014 Preparing for War in the Robotic Age. Can anybody please help with this? Thanks<style type="text/css">
body,div,table,thead,tbody,tfoot,tr,th,td,p { font-family:"Calibri"; font-size:x-small }
a.comment-indicator:hover + comment { background:#ffd; position:absolute; display:block; border:1px solid black; padding:0.5em; }
a.comment-indicator { background:red; display:inline-block; border:1px solid black; width:0.5em; height:0.5em; }
comment { display:none; }
</style>
| Technology | Brief description | Media Title | Excerpt Copy | Year of Publication |
| 3D images in air - Virtual presence in EO / IR | True 3D images are created in air using a strongly-focused, high energy IR pulse laser to create plasma dots of superheated air at selected points. | Technologieverkenning Defensie 2014-16 | 2015 | |
| 3D printing weapons and munition | Application of 3D printing techniques to: 1) generate shapes of energetic components (warhead, gun propellant charge, in-flight propellant or fuel grain) that cannot be manufactured otherwise and that improves the performance of the energetic component; 2 | Technologieverkenning Defensie 2014-18 | 2015 | |
| ∞ endurance UxS | unmanned systems that can function for a prolonged time (infinitely) because they extract energy from their environment (solar cells, electric fields, etc.) | Technologieverkenning Defensie 2014-19 | 2015 | |
| Active protection against high power Directed Energy | Active measures that counter damaging EM and thermal radiation | Technologieverkenning Defensie 2014-21 | 2015 | |
| Active systems for protection of vehicles, ships, containers and fixed infrastructure against fast-moving incoming threats (point defense) | Reduction of passive protection by using active protection systems | Technologieverkenning Defensie 2014-22 | 2015 | |
| Active systems for protection or tactical units, bases and fixed locations against fast-moving incoming threats (area defense) | Protection umbrella for tactical units during movement and basing. Less protected platforms are protected by other platforms with point defence systems | Technologieverkenning Defensie 2014-23 | 2015 | |
| Advanced Energetic Materials | High performance energetics that deliver the required effect against the lowest weight, under all environmental conditions (p.e. increased Temperature: Temperature independent propellants), but is insensitive against external threats (Insensitive Munition | Technologieverkenning Defensie 2014-31 | 2015 | |
| Aero Thermal energy harvesting projectiles | Projectiles that harvest electricity when they are fired, from aerodynamic heating, which is used for guidance and control | Technologieverkenning Defensie 2014-32 | 2015 | |
| Automatically reprogram redeemable and reconfigurable SIGINT / EPC Sensor Systems. | Sensor systems that quickly adapt to new electronic components and functionalities. | Technologieverkenning Defensie 2014-46 | 2015 | |
| Battery improvements | An alternative to traditional box-shaped batteries: the large variety of battery designs should, and almost certainly will, be reduced so that fewer battery models would be needed to cover all exigencies, the power demand of the electronics will be reduce | CTNSP-2014-Policy challenges of accelerating technological change.pdf | Areas that are now maturing and are potentially transformational include advanced solar cells, biofuels, exotic batteries, next-generation fuel cells, ultracapacitors, energy harvesting, and smart power grid systems | 2014 |
| Battery improvements | An alternative to traditional box-shaped batteries: the large variety of battery designs should, and almost certainly will, be reduced so that fewer battery models would be needed to cover all exigencies, the power demand of the electronics will be reduce | CTNSP-2007-Further look at technologies for stabilization operations.pdf | his will be reduced in several ways: the large variety of battery designs should, and almost certainly will, be reduced so that fewer battery models would be needed to cover all exigencies, the power demand of the electronics will be reduced by more caref | 2007 |
| Battery improvements | An alternative to traditional box-shaped batteries: the large variety of battery designs should, and almost certainly will, be reduced so that fewer battery models would be needed to cover all exigencies, the power demand of the electronics will be reduce | Unravelling the energy tether: new power technologies take aim at the dismounted soldier | The US Army's Communications-Electronics Research, Development, and Engineering Center (CERDEC), for example, is pursuing a wearable polymer-based battery that could eventually replace conventional but bulky systems currently carried by soldiers, such as | 2016 |
| Battery improvements | An alternative to traditional box-shaped batteries: the large variety of battery designs should, and almost certainly will, be reduced so that fewer battery models would be needed to cover all exigencies, the power demand of the electronics will be reduce | Technology Trends SurveyFuture Emerging Technology Trends | 3.5.6 Battery Technology The use of renewable energies such as solar and wind have a continuing challenge of ensuring that power supplies are maintained when the sources are intermittent e.g. when the wind is not blowing. To some extent this can be mitiga | 2015 |
| Battery improvements | An alternative to traditional box-shaped batteries: the large variety of battery designs should, and almost certainly will, be reduced so that fewer battery models would be needed to cover all exigencies, the power demand of the electronics will be reduce | 2014 Preparing for War in the Robotic Age | Small, high-density power generation sys- tems. e rise of unmanned and increasingly autonomous systems is leading to platforms and concepts of operation that can take full advantage of the ability to loiter in geographic areas for long periods – sometimes | 2014 |
| Blue Brother (tagging civilians) | Tagging civilians in conflict area’s using small electronic devices. Only part of the population needs to be tagged. Tags embedded in clothing’s. Self powering tags (movements, sun). Capability of tracking individuals or groups of people. Building social | Technologieverkenning Defensie 2014-57 | 2015 | |
| Chip-scale atomic clocks | Using CSACs, military patrols can travel on foot and still carry backpack-sized jammers that prevent radio-controlled improvised explosive devices from detonating. | AF_TechnologyHorizons2010-2030.pdf | Chip-scale atomic clocks | 2011 |
| Close air platforms | Using CSACs, military patrols can travel on foot and still carry backpack-sized jammers that prevent radio-controlled improvised explosive devices from detonating. | Heavy metal Trends in armoured fighting vehicle design.PDF | The second oft-quoted alternative to heavy armour is rotary-wing and fast air assets, particularly close air support platforms such as the Boeing AH-64 Apache attack helicopter and Fairchild Republic A-10 ground attack aircraft, as well as the wide range | 2016 |
| Close air platforms | Using CSACs, military patrols can travel on foot and still carry backpack-sized jammers that prevent radio-controlled improvised explosive devices from detonating. | Heavy metal Trends in armoured fighting vehicle design.PDF | The latest developments in precision weapons provide a further strength to the air argument, with systems such as the MBDA Brimstone anti-armour missile providing aircraft with a valuable low-yield fire-and-forget anti-tank capability | 2016 |
| Close air platforms | Using CSACs, military patrols can travel on foot and still carry backpack-sized jammers that prevent radio-controlled improvised explosive devices from detonating. | Heavy metal Trends in armoured fighting vehicle design.PDF | Regardless of the nature of a future conflict, the inherent advantages of heavy armour and the tank in particular cannot be completely supplanted by alternatives such as aircraft or ATGWs. | 2016 |
<colgroup span="5" width="128"></colgroup><tbody>
</tbody>
<!-- ************************************************************************** -->
As you see, some entries in the 'technologies' column recur in different rows. What I am looking for is a way to generate a new sheet with every technology mentioned only once, with in the third column an overview of the different media titles, separated with a ; S for instance for battery improvements, the third column would have: CTNSP-2007-Further look at technologies for stabilization operations.pdf; Unravelling the energy tether: new power technologies take aim at the dismounted soldier; Technology Trends SurveyFuture Emerging Technology Trends; 2014 Preparing for War in the Robotic Age. Can anybody please help with this? Thanks<style type="text/css">
body,div,table,thead,tbody,tfoot,tr,th,td,p { font-family:"Calibri"; font-size:x-small }
a.comment-indicator:hover + comment { background:#ffd; position:absolute; display:block; border:1px solid black; padding:0.5em; }
a.comment-indicator { background:red; display:inline-block; border:1px solid black; width:0.5em; height:0.5em; }
comment { display:none; }
</style>
