Converting the data from Rows to columns. Or perhaps a Pivot table

I have data in one column, which is repeated in several rows.  Those rows have data that I need to restructure in columns.  Maybe the sample below makes more sense what I need to do.  I need this Ran...