Table - One page report

Hello dear all,

Is there someone who can help me to understand how to buid this visual bellow?

The main challange here is to get data (KPI's names, department and etc) and just after, project in the colunms (monthly) the correspondent values (Being each colunm as a month)

To make it a little bit harder, there are some conditional file formating rules (line by line) where each line is a KPI.

Thank you in advance for any tip or idea.

Best regards,

João Moretti