convert to pivot table
I have a simple table that looks something like this...
Station Order Mean
M01 Aciculata 19.6667
M01 Aciculata 0.3333
M01 Aciculata (null)
M01 Canalipalpata 268
M01 Canalipalpata (null)
M01 Canalipalpata 0.3333
M02 Aciculata 35.3333
M02 Aciculata 2.6667
M02 Aciculata 2
M02 Canalipalpata 8
M02 Canalipalpata 0.3333
M02 Canalipalpata 1
I want to change the rows/columns around so it looks like this...
Aciculata Canalipalpata
M01 10 134.16665
M02 13.33333333 3.1111
I'm pulling my hair out trying to find a solution - I know there is one, but I just can't get my head around how to do it.
I'd very much appreciate any help/advice.
Thanks in advance.
Subject
Written By
Posted
convert to pivot table
November 20, 2015 04:40AM
November 20, 2015 12:04PM
November 26, 2015 02:51PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.