Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Friends,
I need you help in converting the table in the attached excel in to cross table.
Mentioned below is my required output. Also in a separate text box i want the max(first row) ie. 1 in my case. (See the attachment). This is a dynamic file and data keeps coming in.
Thanks in advance.
Output: | |||
BRAND | Week | Sale1 | Sale2 |
A | W1 | 12 | 32 |
A | W1 | 23 | 54 |
B | W2 | 34 | 43 |
B | W2 | 32 | 44 |
Regards
KC
First row would be 0,1,2,3.. sequential?
Yes Kush, it will be sequential
Regards
KC
Any help guys
Hi,
I tried with this multi_header_pivot_import.qvw
May be explore this qvw by Gysbert -> multi_header_pivot_import.qvw
use generic
Gruß Gerry