Name: Capture.JPG Views: 8 Size: 42.2 KB ID: 26266" class="thumbnail" style="float:CONFIG" />
Hi,
I have a table as pasted above that I need to PIVOT.
If the columns are hard to read they are..
REF_ROW_NO REF_SOURCE_FIELD REF_SOURCE_VALUE
I would like the table pivoted so that each ref_row_no is combined together.. hence for ref_row_no =2, i would have a column for value desc with a value of 'Controlled River' and a column called VALUE_ID with a value of 313.
Is this possible?
Thanks,
Rob.