Please help with restructuring data !

[timsaddler]

Please could i have some advice on how to restructure the data from Current Format to Required Format

Any pointers are gratefully received...

Many thanks in advance

[#2]

Hi Tim

you can loop over your table 3 times to load phone, mob, mail under contact field and details fields

or use crosstable to do the same but because you have contact and Details you'll have to loop twice

best regards

Chris

[Gysbert_Wassenaar · Accepted solution]

What an exceedingly bad idea.

See attached qvw.

[timsaddler]

Helped me out of a big hole - thanks Gysbert