So, thanks to tips from great people here I've began to use power query, and it's simply amazing :D :D
Now,there's a transform issue I'm having trouble with - see excel help file attached.
The issue is the following:
-Every row must have date, seller, product and currency.
-The data currently has date and seller in the first two columns, but the product and currency in the first two rows.
Any ideas?
Bookmarks