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

emp no.	Found data	firstname	last name	age	sex	address 1	address 2	Postcode	dob
1	dave smith 22 wheel rd b22 2bb	dave	smith			22	wheel rd	b22 2nn
2	scott 22 m 33 drive rd b22 2nn 19/02/1988	scott		22	m		33 drive rd	b22 2nn	19/02/1988
3	james bob m 22 b22 2nn 20/03/1957	james	bob		m	22		b22 2nn	20/03/1957

<tbody>
</tbody>

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