Hallo All,
I have a "small" problem in PQ. I have in column product IDs and in another column all EAN codes related to each article (product ID). It naturally means when I have 5 EANs related to one product, the mentioned products is in 5 lines.
Desired outcome would be: Each product ID is in one (1) row and Query transpose thos 5 codes in new columns (there is not more than 5 EANs to each code).
Using transpose in PQ however transpose all codes (as they are unique) to adequate number of the columns .
PLease see details in attached table.
Thank you in advance.
Bookmarks