Reorganise Data from Rows into Columns to be uploaded to my CRM System

[birdoo2]

Hi,

I am trying to organise a selection of customer data as follows.

I have the data currently broken down by row with, Company, Address and Main Contacts in the same row. What need is as follows

1. The Main Contact data and Excel to be moved into a new row that will also contain the Company and their address.

Is there a rule or Macro that can be run that would create this data. I have a large file and while copy pasting is an option, I think Excel has an easier way.

I have attached a sample of what I am looking for. I need row 2 to be split out as in row 9,10 and 11.

I would be using this feature on a weekly basis and would need to be applicable to other spreadsheets with similar data.

Thanks

birdoo2

[birdoo2]

Moved to commercial services area

[arlu1201]

Thread closed.