wacker | A WPA3 dictionary cracker

I am trying to create a xsl file which has data in xml file. The expected output should only have states of vehicles towed from Arizona,Florida and New York (The xml file has state codes in output it needs to be full name of the state in the output example(FL->Florida). Link to the color codes(https://www.sarasotataxcollector.com/dealers/color-codes) which should be an abbreviation again in the output in xml it is just the color code. The most recently towed vehicle must be listed first. I have attached until where I was able to progress, I am stuck on the following scenarios.

1. Structuring of the output and the corresponding naming structure.
2. I'm not sure how abbreviation works in XSl for state name and color codes to get the below output. I am a beginner in xsl, xml attaching what I've tried until now. I would really appreciate it if anyone can guide me on how to resolve the problem statement. This is first time reaching out to the stack overflow community. :) Expected output should be as follows, This is a sample but with my xml data it should be as the same structure as below.

I'm merging 5 files. Each file has certain column names which are same across the other files. I used this answer to perform the concat operation. There is one column which is unique in all files i.e ID. When I merge the columns I'm noticing the suffix(_x, _y) being applied to end of the column names(due to merge functionality) which are repeating. How can I merge these columns into a single column (Irrespective of null values).

eg: