scottyyboyy
New Member
- Joined
- Feb 2, 2015
- Messages
- 41
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
<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
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