How to collect data from 2 colums

[mathes]

I have a table with 2 colums "Name" & "Value". Each set of data have 5 Names "Data1", "Data2", "Data3", "Data4" & "Data5", each with different values. The sheet contains about 1000 set of data, each placed rowwise. The data sheet looks like this

Data1 <text>
Data2 <text>
Data3 <text>
Data4 <text>
Data5 <value>
****
Data1 <text>
Data2 <text>
Data3 <text>
Data4 <text>
Data5 <value>
****
Data1 <text>
Data2 <text>
Data3 <text>
Data4 <text>
Data5 <value>
****
etc...

I want to create a new worksheet with data sorted like this

Data1 Data2 Data3 Data4 Data5
<text> <text> <text> <Text> <value>
<text> <text> <text> <Text> <value>
<text> <text> <text> <Text> <value>

Can anybody give me a macro for this?

Thanks in advance
mathes

[Domski]

Should be easy enough, could you upload a sample workbook so we know the format of the initial data rather than from your post.

Dom