This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a table with this structure:
How can I change the structure to get the follwoing table:
I suggest the following:
1. Transpose the Qty columns
2. Parse the Date to yyyyMMdd and create the Prod type
3. Cross tab to get to the required layout
4. Dynamic rename to label the columns correctly