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
