Reorganize a table

Dear community,

I'd like to re-organize a table. What I have is this:

ID1ID2Species1Species2Value1Value2
...




...




what I like to have is this:


ID1ID2
Species1Species2Species1Species2

ID1

Species1


value1value1value1

Species2

value2
value1value1
ID2

Species1

value2

value2



Species2

value2

value2

value2


Additionall task: the cells containing values shoud be colored in a heatmap kind of manner.

How can that be done in Pipeline Pilot?

Thanks,

Bonina