Aligning ID Fields

Codymur

Right now I have I have 5 ID fields and I am trying to align them all to match up. 

For some reason this works all the way to 3303 and then for some reason they are get out of grouping.

IE:

ID	ID2	ID3	ID4	ID5
3303	3303	3303	3303	3303
3303	3303	3304	3304	3304
3304	3304	3305	3305	3305
3305	3305	3303	3303	3303
3306	3306	3304	3304	3304

I am attempting to see if there is a way that I can get the Last 3 ID fields to align with the first 2 ID fields.

Thank you for your assistance!

CharlieS

I approached this by transforming the data to a single column and sorting it all at once. I used a Tile tool to assign a record ID (think RecordID field with Group By) to transform it back to the original data structure. 

Check out the example solution that's attached and let me know if this works for you.

20181101-SortMultiple.yxmd