Export data structure

-- HikaShop version -- : 4.3.0

Now if I export order data with mass action I have all data from one purchase in one row. So if customer buy 1 product, there is one product column. If buys 2 products, there is two product columns. So I never know how many columns will be.
What I need is this structure:

Is there any known extension to achive this?

Hi,

If you don't want to "mess" with it directly in phpMyAdmin (e.g. by creating a MySQL view for it), there are numerous tools on the JED for extraction and export of data from the database.
I'm using Plotalot ( extensions.joomla.org/extension/plotalot/ ) for such and other cases, as it can not only create charts and infographics but also tables incl CSV export.
However, for all of these extensions knowledge of MySQL is required for writing the database queries.