restructuring data in the load

[samuel_brierley]

below is a sample of data and how it is arranged however is it possible to rearrange it in the load sequence so my collumns are

Time, Type, 'MainCarriagewayDataFilteringOutput.site2.o',  'MainCarriagewayDataFilteringOutput.site2.q'

                                        Value                                                                                Value

hopefully that makes sense what im after is a collumn for each Name and the corresponding value at that time for that Name.

thanks for any help

'Time'	'Type'	'Name'	'Value'
00:00		'MainCarriagewayDataFilteringOutput.site2.o'	1
00:00		'MainCarriagewayDataFilteringOutput.site2.q'	2
00:01		'MainCarriagewayDataFilteringOutput.site2.o'	3
00:01		'MainCarriagewayDataFilteringOutput.site2.q'	4
00:02		'MainCarriagewayDataFilteringOutput.site2.o'
00:02		'MainCarriagewayDataFilteringOutput.site2.q'
		'MainCarriagewayDataFilteringOutput.site2.o'

[alexandros17]

You may use crosstable, look for it in help