e.g.: Input data - two rows
COL1 COL2 COL3 COL4
Dogs Pets Beagle Patchy
Bulldog Brown
Terrier Beige
Cats Wild Marbled Cat Spotted
Bay Cat Brown
would like the output (five rows) to be:
COL1 COL2 COL3 COL4
Dogs Pets Beagle Patchy
Dogs Pets Bulldog Brown
Dogs Pets Terrier Beige
Cats Wild Marbled Cat Spotted
Cats Wild Bay Cat Brown
咁樣方便寫formula好多