Hello,
I was wondering if it is possible to divide one given column into multiple columns for which there is no delimiter or uniform width space.
Here is an example of 3 rows of the data -
Location Address City State Zip Phone Number Fax Number Email Address
Kinokuniya Plaza 11803 Kino Ln Newark New Jersey 39841 (804) 454-9998 N/A
Mythos Place 93 Santos Drive San Francisco California 99312 (626) 123-9088 N/A
Any help would be truly appreciated
Thank you in advance!