Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have some data layed out like this
Territory Towns
1 A,B,C,F
2 G,Y,W,E
What I want to do it transform it to this…
Territory Town
1 A
1 B
1 C
1 F
2 G
2 Y
2 W
2 E
Any ideas how I can do this?
Load Territory, subfield(Towns, ',') as Town
Rob
Hi,
Hope the attached file helps you.
Regards,
Jagan.