Transforms text in a single column in a table with multiple columns in vba
' Changes this -----> INTO -----> this
'
' Mickey Mouse Mickey Mouse Mainstreet USA Evening shift
' Mainstreet USA Donald Duck Frontierland Japan Breakfast
' Paris Daisy Duck ...etc....
' evening shift
'
' Donald Duck
' Frontierland
' Japan
' Breakfast
'
' Daisy Duck
' ...etc...
'