Format data fields into correct columns - Consultant needed!

conkers

New Member
Joined
Oct 17, 2006
Messages
1
I have a spreadsheet with address details. Some data is in the wrong columns, Country in Postcode, Postcode in country. This varies from row to row.

How do I format the sheet to have all the "Country" data in that column, all the "Postcode" data in that column and so on.

It must be possible?
:x
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

bjwillingham

Active Member
Joined
Jun 17, 2003
Messages
287
One suggestion:

Copy both columns to the right.

Then develop an IF() formula that can determine if the value in one of the columns is the Postcode. Have the If() formula copy the appropriate value depending on the answer and the column it is in.
 

Forum statistics

Threads
1,136,510
Messages
5,676,281
Members
419,617
Latest member
Shane50GT

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
Top