this looks like a cross tab... ie data source has:
| Account Description | Asset Number | Name | Value |
| 762400 | 1926206 | Prior Period | 35.38 |
| 762400 | 1926206 | Current Period | 35.58 |
when you cross tab this you get what you have (with some minor regex swapping of characters).
summarize tool group by and max value is probably the easiest way to fix this.If (and only if) it's dynamic and more than a few columns -- -and you need something dynamic you could ---do something more complicated like tile tool - unique value for your two primary keys. cross tab on tile_sequence number as your column ---> value as your value (concat/sum/doesn't really matter what aggregation you use) ---> that should solve problem 1. next you have to fix your column names --- so go back to your tile tool and add a second cross tab ---> filter for tile_number --- not tile tile_sequence_number - 1 -> hook up a dynamic rename between the first datastream and hook the results of the second tile tool into the right dynamic rename anchor. use the change column names based upon right anchor option and map the column name in a to the tile_sequence value -> replace with name.
