Append color values to field value

[Vignesh-107]

I have a query result . i want to append the three colors  based on values  and the table is dynamic based on the time frame 

column Messages and Nov20 - no change should be same 

Messages	Nov 20	Dec 20	Jan 20	Feb 20
Messge 0	0	1	0	0
Messge 1	1	3	1	1
Messge 2	11	0	0	0
Messge 3	1	0	0	0
Messge 4	9	5	0	0
Messge 5	1	1	0	0
Messge 6	1	1	0	0
Messge 7	0	1	0	0

column Dec20 Jan20 Feb20 - values should append field value and with color value

Messages	Nov 20	Dec 20	Jan 20	Feb 20
Messge 0	0	1 GREEN	0 RED	0 YELLOW
Messge 1	1	3 GREEN	1 RED	1 YELLOW
Messge 2	11	0 RED	0 YELLOW	0 YELLOW
Messge 3	1	0 RED	0 YELLOW	0 YELLOW
Messge 4	9	5 RED	0 YELLOW	0 YELLOW
Messge 5	1	1 YELLOW	0 RED	0 YELLOW
Messge 6	1	1 YELLOW	0 RED	0 YELLOW
Messge 7	0	1 GREEN	0 RED	0 YELLOW

[ITWhisperer]

You asked a very similar question (which I answered) here - the main difference being not adding the colour value to the first date column. As I hinted at in the other post, it might be easier to solve from the original query used to generate the table. Are you able to share this? Did you try the technique shown in the other post?