Hi, I need assistance in transforming Table 1 below into Table 2 The last 2 characters of the column headers need to match. I have color coordinated them below. The last two characters of the program Id heading (A1 or A2) need to match the last two characters of the rate and the date columns. I am only providing a sample of my data as the dataset would be too large to attach. Thank you!! Have: Table 1 Program_ID.A1 Program_ID.A2 CCF_MIN.A1 CCF_MAX.A1 CCF_DATE.A1 CCF_MIN.A2 CCF_MAX.A2 CCF_DATE.A2 12345 78907 $1 $2 10/23/2017 $3 $4 12/15/2019 23456 21278 $1 $2 10/23/2017 $3 $4 12/15/2019 34456 56785 $1 $2 10/23/2017 $3 $4 12/15/2019 Want: Table 2 Program_ID CCF_MIN CCF_MAX CCF_Date 12345 $1 $2 10/23/2017 23456 $1 $2 10/23/2017 34456 $1 $2 10/23/2017 78907 $3 $4 12/15/2019 21278 $3 $4 12/15/2019 56785 $3 $4 12/15/2019
... View more