Generic Load will transform the data as it is loaded. Personally I always prefer the tall thin table type you have already. I wonder if a slightly different solution might be better for you. In a straight table chart add Customer as your dimension, and as an expression add:
Concat(DISTINCT [contact number],', ')
Hope this helps,
I am really new to Qlikview, find it really hard to do simple formatting using table box. can someone point me to the right direction? thank you.
|customer||contact number 1||contact number 2||contact number 3|