Column to rows and highlight difference between values in the same group

I have a huge table with data structured like this:

And I would like to display them in Spotfire Analyst 7.11 as follows:

Basically I need to display the columns that contain "ANTE" below the others in order to make a comparison. Values that have variations for the same ID must be highlighted.

I also have the fields "START_DATE_ANTE" and "END_DATE_ANTE" which have been omitted in the example image.

(1) Answer

Login