Transpose wont work - too much data

Hi There,

I asked this question a while ago but I don't think I explain myself very well! Here's the information I have:

COLUMN A COLUMN B

RunspaceId Data 1
Cost Data 2
ADCost Data 3
ExchangeCost Data 4
MaxMessageSize Data 5
Sites Data 6
AdminDisplayName Data 7
ExchangeVersion Data 8
Name Data 9
DistinguishedName Data 10
Identity Data 11
Guid Data 12
ObjectCategory Data 13
ObjectClass Data 14
WhenChanged Data 15
WhenCreated Data 16
WhenChangedUTC Data 17
WhenCreatedUTC Data 18
OrganizationId Data 19
OriginatingServer Data 20
IsValid Data 21

RunspaceId Data 1
Cost Data 2
ADCost Data 3
ExchangeCost Data 4
MaxMessageSize Data 5
Sites Data 6
AdminDisplayName Data 7
ExchangeVersion Data 8
Name Data 9
DistinguishedName Data 10
Identity Data 11
Guid Data 12
ObjectCategory Data 13
ObjectClass Data 14
WhenChanged Data 15
WhenCreated Data 16
WhenChangedUTC Data 17
WhenCreatedUTC Data 18
OrganizationId Data 19
OriginatingServer Data 20
IsValid Data 21

This repears upto 200 times and I have lots of these outputs with the value changing in column B but the format is essenially the same.

I'm trying to work out how I can take Column A, make the data in there the title of each colum and then populate the relivant colum with the correct data based on it's entry next to it (in the above example column b.

I'd like something like this in the end (I've removed some to the columns for ease of copy/paste)

RunspaceId Cost ADCost ExchangeCost MaxMessageSize
Data 1 Data 2 Data 3 Data 4 Data 5

I can edit each script with the relivant column entrys that it should look for. Transpose wont work due to the sheer amount of data - it all ends up on two lines

Any help would be appreciated - I'm looking at doing this manually at the moment and I have over 20,000 sections to work though!!

Best regards, Wilbbleman