contemporary
New Member
- Joined
- Jul 27, 2015
- Messages
- 5
Hi All,
I've searched for this, perhaps not hard enough! but I haven't see it covered the way I'm looking for it
I've a csv file like this
and I am looking to get excel to combine the rows so that i can get it to show like this
Any suggestions or tips greatly appreciated
I've searched for this, perhaps not hard enough! but I haven't see it covered the way I'm looking for it
I've a csv file like this
003R91165A4 Brand Xerox 003R91165A4 Colour White 003R91165A4 Dimensions 210x297mm 003R91165A4 Eco-Aware Yes 003R91165A4 For Copiers Yes 003R91165A4 For Laser Printers Yes 003R91165A4 Grammage 80gsm 003R91165A4 Manufacturer Xerox 003R91165A4 Recycled Product 100% Recycled Material 003R91165A4 Size A4 003R91165A4 Type Plain Paper 003R91166A3 Brand Xerox 003R91166A3 Colour White 003R91166A3 Dimensions 297x420mm 003R91166A3 Eco-Aware Yes 003R91166A3 Manufacturer Xerox 003R91166A3 Recycled Product 100% Recycled 003R91166A3 Size A3 003R91166A3 Type Plain Paper
<tbody>
</tbody>
and I am looking to get excel to combine the rows so that i can get it to show like this
003R91165A4 Brand Xerox Colour White Dimensions 210x297mm Eco-Aware Yes For Copiers Yes For Laser Printers Yes Grammage 80gsm Manufacturer Xerox Recycled Product 100% Recycled Material Size A4 Type Plain Paper 003R91166A3 Brand Xerox Colour White Dimensions 297x420mm Eco-Aware Yes Manufacturer Xerox Recycled Product 100% Recycled Size A3 Type Plain Paper
<tbody>
</tbody>
Any suggestions or tips greatly appreciated