Dear community,
I'd like to re-organize a table. What I have is this:
ID1 | ID2 | Species1 | Species2 | Value1 | Value2 |
---|---|---|---|---|---|
... | |||||
... |
what I like to have is this:
| ID1 | ID2 | |||
---|---|---|---|---|---|
Species1 | Species2 | Species1 | Species2 | ||
ID1 | Species1 | value1 | value1 | value1 | |
Species2 | value2 | value1 | value1 | ||
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