Help...
My data is trapped in a single column. The actual data is copied below.
Two things. I know I can parse using the hard return. But, how do I reset for each entry? Each new entry starts with a WYR32#### permit number (always 9 characters in length).
WYR320010 |
Bentonite Performance Minerals |
Lovell Plant |
44.858783/‐108.227931 |
WYR320011 |
Bentonite Performance Minerals |
Colony Mine Pit |
44.858783/‐104.143536 |
WYR320026 |
WYO‐Ben, Inc. |
Sage Creek Mill Site |
44.8465/‐108.4358 |
WYR320027 |
WYO‐Ben, Inc. |
Stucco Plant Site |
44.5862/‐108.1162 |
WYR320028 |
WYO‐Ben, Inc. |
Lucerne Plant Site |
43.7348/‐108.166 |
WYR320029 |
WYO‐Ben, Inc. |
Big Horn Basin Mines |
44.6441/‐107.9947 |
WYR320031 |
American Colloid Company |
Colony West Plant |
44.869678/‐104.161433 |
WYR320034 |
American Colloid Company |
Cetco Lovell Plant Site & Field Mining Ops |
44.855278/‐108.329236 |
WYR320096 |
Black Hills Bentonite |
Mills & HT Bentonite Plant Site |
42.850306/‐106.35413 |
WYR320097 |
Black Hills Bentonite |
Permit # 339C ‐ Mayworth Mine Site |
43.842361/‐106.790028 |
WYR320099 |
Black Hills Bentonite |
Worland Bentonite Plant Site |
44.0425/‐107.955556 |
WYR320100 |
Black Hills Bentonite |
Permit # 533 ‐ Greybull Mine Site |
44.637833/‐107.965778 |
WYR320102 |
Black Hills Bentonite |
Permit # 281c ‐ Ten Sleep Mine Site |
44.102333/‐107.620444 |
WYR320103 |
Black Hills Bentonite |
Permit # 268C ‐ Midwest Mine Site |
43.349889/‐106.351111 |
WYR320104 |
Black Hills Bentonite |
Permit # 248C ‐ Kaycee Mine Site |
.1782/‐106.5192 |
WYR320105 |
Black Hills Bentonite |
Casper Bentonite Plant Site |
42.845722/‐106.357611 |
WYR320215 |
Black Hills Bentonite |
Permit # 685 ‐ Oshoto Mine Site |
44.616056/‐104.897806 10110201 Little Missouri |
WYR320216 |
Black Hills Bentonite |
Thornton Bentonite Plant Site |
44.158528/‐104.7395 |
WYR320605 |
Black Hills Bentonite |
Permit # 745 ‐ Iron Mountain Mine Site |
44.271361/‐104.735833 |
WYR320832 |
Tolsa Wyoming Bentonite |
Tolsa Wyoming Bentonite |
43.022168/‐106.626238 |
