show row data into columns RRS feed

  • Question

  • Hi guys

    i have data coming in multiple rows and want to show same data in columns like multiple colours per product. colour are fixed in numbers i.e only three colours are there per product not more than that..

    the major problem is that i can't use row_number function

    sample data is like this

    id product_name colour

    101 A red

    101 A black

    101 A Green

    result required:-

    id  product_name colour1 colour2 colour3

    101 A red black green

    thanks & Regards

    • Edited by leo_dec Thursday, September 12, 2013 9:01 PM
    Thursday, September 12, 2013 8:58 PM