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

@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!

Rearrange Output.yxmd