Rearrange output

[Brad1]

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.

[patrick_digan · Accepted 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!

[Brad1]

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.

[Brad1]

Not sure what I changed or did - but it's working now.  Thanks very much.