There is probably an easy way to do this - maybe.
I would like to go from this current output:
Target Location Name | Target Location Addr | Alt Location Name | Alt Location Addr | Distance |
Store A | 123 Main | Store B | 124 Main | 1.2 |
Store A | 123 Main | Store C | 126 Main | 2.3 |
To this output:
Target Location Name | Target Location Addr | Alt Location Name1 | Alt Location Addr1 | Distance1 | Alt Location Name2 | Alt Location Addr2 | Distance2 |
Store A | 123 Main | Store B | 124 Main | 1.2 | Store C | 126 Main | 2.3 |
Any ideas? Thanks in advance.
Solved! Go to Solution.
@Brad1 I think you can use a transpose and crosstab along with some multi-row formulas.
Let me know if this doesn't quite solve it for you!
Hey Patrick,
I'm sure I'm doing something wrong - being pretty new at this. Your Crosstab tool has the Error "At least one Crosstab Method must be specified (Not counting Total Row)". If I choose one then that creates an error with the Dynamic Rename tool.
I've added your workflow to mine and I'm getting the same errors. I've try changing around various variables within different tools since yesterday and it's just not working for me. I wouldn't worry about making changes. I may just need to tell the end-users there's a new format. Thanks for your help.
Not sure what I changed or did - but it's working now. Thanks very much.