Query help

I need a query to get the expected results..

Here is sample data...

Table: Mrelation

Mastercolumn detailscolumn


/test/sample/data /detail/folder1/plac2
/test/sample/data /detail/folder1/plac3
/test/sample/data /detail/folder1/plac4
/test/sample/data /detail/folder1/pla22

Expected output:

Mastercolumn detailcolumn1 detailcolumn2 detailcolumn3 detailcolumn4


/test/sample/data /detail/folder1/plac2 /detail/folder1/plac3 /detail/folder1/plac4 /detail/folder1/pla22

Thanks for your help..

see UNPIVOT