Duplicate row data and transfer to column

[saundersxvi]

Hello,
I've got a txt file with over 200+ entries that I want to convert into a table. How is it possible to have data formatted as the following:

Name: Tom
Age: 23

Name: Harry
Age: 82

Into the following

[TABLE="width: 500"]
<tbody>[TR]
[TD]Name:[/TD]
[TD]Age:[/TD]
[/TR]
[TR]
[TD]Tom[/TD]
[TD]23[/TD]
[/TR]
[TR]
[TD]Harry[/TD]
[TD]82[/TD]
[/TR]
</tbody>[/TABLE]

I tried data import but kept getting the Name and age repeated, which doesn't help.

Thanking you in advance.

David

 

[Michael M]

Is Name and Tom in the same cell ?
Same with age ??
Is that all the data for each person ?

 

[saundersxvi]

Hi Michael,

'Name' and 'Tom' are in different cells. 'Name' would be the header cell. Same with age.

There's over 200 names in the txt file with over 25+ questions asked per person. I simplified the txt and table to save space.

David

 

[Michael M]

So, what happens with the 25+ Q&A ??
Can you upload the file to DropBox and post a link back here ??

 

[saundersxvi]

So, what happens with the 25+ Q&A ??
Can you upload the file to DropBox and post a link back here ??

Issue can be closed. Resolved matter through other means. Thanks for your assistance

 

[Michael M]

OK, glad you got it sorted...