Bill Jones,    Home Depot Inc,   GA, 30333
Sharon Lee Smith,   Cable News Network, GA,  33333
B. Amos   , Hill Street Cafe,  CA,  95013


We want to reformat to
Bill Jones,GA 30333,Home Depot Inc
...


1,3s/\([^,]*\),\([^,]*\),\([^,]*\),\([^,]*\)/\1,\3 \4,\2/
above does not remove spaces

this will remove spaces
1,3s/[ \t]*,[ \t]*/,/g