Adding all data into 1 cell from a row ignoring blanks and adding title before whats in non blank cells

[scottyyboyy]

Hi All,

I have searched all over the net and cant find the answer.

I have a spreadsheets with hundreds of thousands of rows and hundreds of columns, I need to pull out the data that's in a row and add all into 1 cell but where it finds data in a row i need it to take the title name to the word it finds in the row.

hope this makes sense please see below

[TABLE="class: grid, width: 200, align: center"]
<tbody>[TR]
[TD]emp no.[/TD]
[TD]Found data[/TD]
[TD]firstname[/TD]
[TD]last name[/TD]
[TD]age[/TD]
[TD]sex[/TD]
[TD]address 1[/TD]
[TD]address 2 [/TD]
[TD]Postcode[/TD]
[TD]dob

[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]dave smith 22 wheel rd b22 2bb[/TD]
[TD]dave[/TD]
[TD]smith[/TD]
[TD][/TD]
[TD][/TD]
[TD]22[/TD]
[TD]wheel rd[/TD]
[TD]b22 2nn[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]scott 22 m 33 drive rd b22 2nn 19/02/1988
[/TD]
[TD]scott[/TD]
[TD][/TD]
[TD]22[/TD]
[TD]m[/TD]
[TD][/TD]
[TD]33 drive rd[/TD]
[TD]b22 2nn[/TD]
[TD]19/02/1988[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]james bob m 22 b22 2nn 20/03/1957[/TD]
[TD]james[/TD]
[TD]bob[/TD]
[TD][/TD]
[TD]m[/TD]
[TD]22[/TD]
[TD][/TD]
[TD]b22 2nn[/TD]
[TD]20/03/1957

[/TD]
[/TR]
</tbody>[/TABLE]


the green text is what i need but this is for 100,000 rows and goes to like column VZ ish.

Thanks in advance if someone can help me
Scott

 

[Fluff]

You're welcome & thanks for the feedback