Rearranging data

Hi,

I am looking for a way to automate / formulate the 'transposition' of data. The data is held in multiple rows across three columns and I want the final product to be held in a single row with the three colums repeated across the one row - please refer to the attached example (a bit difficult to explain in words!).

I have tried a Pivot Table but have not been able to get the data into a single row Perhaps I'm not using Pivot Tables correctly (I am a novice in 'Pivots' and not very goosd in Excel in general). Perhaps the solution is a formula, or something else??

Cheers,
BFee