Rearrange Excel List

[andylowekcx]

Hi Everyone

I have an excel list that i need to rearrange in preparation to be imported.

The list contains a list of companies, address, contacts & contact details. Currently a new row is made for each contact and the company name is duplicated.

example of current setup

Column A - Company Name	Column B - Company Address	Column C - Contact Name	Column D - Contact Email
Andy Electrical	1 High Street	Bruce Wayne	Batman@gmail.com
Andy Electrical	1 High Street	Peter Parker	Spiderman@gmail.com
No Leaks Plumbing	55 Water Lane	Captain Cook	Hook@Office.com

However for the import i need each company to only use 1 row and all the contacts to be on one column.

Column A - Company Name	Column B - Company Address	Column C - Contact Name 1	Column D - Contact Email 1	Column E- Contact Name 2	Column F - Contact Email 2
Andy Electrical	1 High Street	Bruce Wayne	Batman@gmail.com	Peter Parker	Spiderman@gmail.com
No Leaks Plumbing	55 Water Lane	Captain Cook	Hook@Office.com

Is it possible to reorganise my list like the second table, without doing it manually as I have almost 1000 contacts. Some company's have up to 10 contacts

Thanks in advance

Andy

 

[Fluff]

Are you saying the formula I suggested didn't work?