[TABLE="width: 575"]
<tbody>[TR]
[TD="class: xl64, width: 575"]Hi All members,
I have around 2K records in a excel sheet with fields, Company, City, First name, Last name, Email, Then First name, Last Name, Email, Then First name Last name, Email, and so on....
Let me explain this. Each row contain a Company details and their workers first name, last name, email.
Each company have at least one worker and up to 8 workers.
Example Picture - It shows One Company one city but 6 workers working for them but data is in a single row.
[/TD]
[/TR]
</tbody>[/TABLE]
Here is what i want to organize them in excel sheet. In above picture it shows 1 Company with six workers in a single row. I want six rows for one company but only difference is worker name and email.
I want to know if there is a way to do this in a better way? Other than first inserting rows then copying and pasting name emails.
Thank you in advance
<tbody>[TR]
[TD="class: xl64, width: 575"]Hi All members,
I have around 2K records in a excel sheet with fields, Company, City, First name, Last name, Email, Then First name, Last Name, Email, Then First name Last name, Email, and so on....
Let me explain this. Each row contain a Company details and their workers first name, last name, email.
Each company have at least one worker and up to 8 workers.
Example Picture - It shows One Company one city but 6 workers working for them but data is in a single row.
[/TD]
[/TR]
</tbody>[/TABLE]
| Unknown | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | |||
| 255 | Company Name | City/Prov | First 1 | Last 1 | Email 1 | First 2 | Last 2 | Email 2 | First 3 | Last 3 | Email 3 | ||
| 256 | ISTITUTO CLINICO HUMANITAS | Rozzano | Simona | Camarda | simona.camarda@humanitas.it | Monica | Florianello | ufficio.stampa@humanitas.it | Marta | Galbiati | marta.galbiati@materdomini.it | ||
Filtered | |||||||||||||
Here is what i want to organize them in excel sheet. In above picture it shows 1 Company with six workers in a single row. I want six rows for one company but only difference is worker name and email.
| Unknown | |||||||
|---|---|---|---|---|---|---|---|
| A | B | C | D | E | |||
| 255 | Company Name | City/Prov | First Name | Last name | |||
| 256 | ISTITUTO CLINICO HUMANITAS | Rozzano | Simona | Camarda | simona.camarda@humanitas.it | ||
| 257 | ISTITUTO CLINICO HUMANITAS | Rozzano | Monica | Florianello | ufficio.stampa@humanitas.it | ||
| 258 | ISTITUTO CLINICO HUMANITAS | Rozzano | Marta | Galbiati | marta.galbiati@materdomini.it | ||
| 259 | ISTITUTO CLINICO HUMANITAS | Rozzano | Tatiana | Debelli | tatiana.debelli@gavazzeni.it | ||
| 260 | ISTITUTO CLINICO HUMANITAS | Rozzano | Laura | Capardoni | laura.capardoni@humanitas.it | ||
| 261 | ISTITUTO CLINICO HUMANITAS | Rozzano | Walter | Bruno | walter.bruno@humanitas.it | ||
Filtered | |||||||
I want to know if there is a way to do this in a better way? Other than first inserting rows then copying and pasting name emails.
Thank you in advance
