Macro Required or a Shortcut

[Abbas999]

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.

<tbody>
</tbody>

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	Email
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

 

[Abbas999]

Are there any empty rows or columns between A260 and the end of your starting data?

Unknown

	A	B	C	D	E	F	G	H
423	LEGA CONSUMATORI	Milano	Laura	Praderi	ufficiostampa@legaconsumatori.it
424	LEGA DEL FILO D'ORO - ONLUS	Osimo	Gianluca	De Tollis	raccoltafondi@legadelfilodoro.it	Chiara	Ambrogini	ambrogini.c@legadelfilodoro.it
425	LEGA ITALIANA PER LA LOTTA CONTRO I TUMORI	Roma	Ufficio	Stampa	ufficio.stampa@lilt.it
426	LEGA NAZIONALE PER LA DIFESA DEL CANE	Milano	Carolina	Fagioli	fundraising@legadelcane.org	Francesca	Fagioli	redazioneweb@legadelcane.org
427	LEGA NORD PADANIA - SEGR. FEDERALE	Milano	Iva	Garibaldi	ivagaribaldi@gmail.com
428	LEGA PALLAVOLO - SERIE A FEMMINILE	Milano	Daniele	Todisco	todisco@legavolleyfemminile.it	Consuelo	Mangifesta	mangifesta@legavolleyfemminile.it
429	LEGA PALLAVOLO - SERIE A MASCHILE	BOLOGNA	Stefania	Bonamici	bonamici@legavolley.it	Chiara	Mazzoni	mazzoni@legavolley.it
430	LEGA SERIE A - LEGA SERIE B	Milano	Tiziano	Mauri	stampa@legaseriea.it	Alberto	Monguidi	stampa@legaserieb.it
431	LEGALCOMMUNITY	Milano	Stefania	Bonfanti	stefania.bonfanti@legalcommunity.it
432	LEGAMBIENTE	Roma	Milena	Dominici	m.dominici@legambiente.it
433	LEGANCE - AVVOCATI ASSOCIATI	Milano	Francesca	Castiglioni	fcastiglioni@legance.it	Elisa	Zetti	ezetti@legance.it
434	LEGISLAZIONE TECNICA SRL	Roma	Piero	de Paolis	piero.depaolis@legislazionetecnica.it
435	LEICA - LEICA CAMERA ITALIA SRL	MILANO	Giada	Triola	giada.triola@leica-camera.com
436	LENOVO ITALY SRL	San Felice - Segrate	Simona	Menghini	smenghini@lenovo.com

<tbody>
</tbody>

Filtered


​

THIS SHOWS, Each Company have at least one worker. And up to 8 workers. Maybe code understands if there are more than one worker then do the macro?