Help Transformation steps in Excel import wizard. Changing formatting
I have Financial files in Excel I am trying to pull from that look like the top portion below. To make use of the data I need to grab the Product A and B headers and align it with the sales and returns as well as grab the Gross Sales and Return headers and align them next to the appropriate rows as seen in the lower section to make this usable in QlikView.
There are some transformation steps which mention Fill, Column, Uwrap and Rotate. The Help file doesn't give much information that's useful.