Hi their..
Is their any good way to separate the values in the column “additional attributes” when you export products to Exel or Open office.
If you want to export all the attributes in Magento we get A LOT of attributes in the same column. ( see link for default )
https://gyazo.com/bfe2ce1dc998f9b9d91ed05cdae598ab
One way to solve this issue is to go to Data—> Data to text and separate the fields.
The problem is that the different attributes get separated in different ways. See attacked link.
https://gyazo.com/b2c8cd93ff3a632b156887071e4f889b
To make the formula Data to text work properly in the column additional attributes I need to be able to show all the commas from the original csv file in this column.
The the function would work excellent.
Solution two.
Is their any good way to make Exel understand the all the information with the same attribute like volume= or size= should be located in the same column?
Kind regards Andreas AB Väskan
