show row data into columns

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