andylowekcx
New Member
- Joined
- Feb 26, 2015
- Messages
- 7
- Office Version
- 365
- Platform
- 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
However for the import i need each company to only use 1 row and all the contacts to be on one column.
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
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