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 |
Solved! Go to Solution.
I've attached a workflow that shows a few tricks how to get this going. A Multi-Row Formula tool utilizing a RegEx_Match( function will identify the "WYR32####" pattern using "WYR32\d{4}", and start a new RecordID value when that occurs.
After that, the Tile and Cross Tab tools get the data "more horizontal". I imagine this is what you had in mind for this data. I hope this helps!
Yah. I was just looking up an old example I had of a similar challenge. I forgot all about the Multi-Row Tool's applicability in this scenario. Many thanks.
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |