Rows to Column

Hi,

I believe this is something basic but I haven't found the answer in the forums. Some similar things, but they haven't worked for me. I am trying to convert some rows into attributes. I have som data that looks like this:

Name 1

attr1

attr2

attr3

Name 2

attr1

attr2

attr3

All in the same column. I want to transpose or pivot into this:

Name 1 attr1 attr2 attr3

Name 2 attr1 attr2 attr3

I've been trying for hours. Please help. Thanks.