Rearrange Excel List

andylowekcx

New Member
Joined
Feb 26, 2015
Messages
7
Office Version
  1. 365
Platform
  1. Windows
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 NameColumn B - Company AddressColumn C - Contact NameColumn D - Contact Email
Andy Electrical1 High StreetBruce WayneBatman@gmail.com
Andy Electrical 1 High StreetPeter ParkerSpiderman@gmail.com
No Leaks Plumbing55 Water LaneCaptain CookHook@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 NameColumn B - Company AddressColumn C - Contact Name 1Column D - Contact Email 1Column E- Contact Name 2Column F - Contact Email 2
Andy Electrical1 High StreetBruce WayneBatman@gmail.comPeter ParkerSpiderman@gmail.com
No Leaks Plumbing55 Water LaneCaptain CookHook@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
 
Are you saying the formula I suggested didn't work?
 
Upvote 0

Forum statistics

Threads
1,226,771
Messages
6,192,926
Members
453,767
Latest member
922aloose

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top