Use a spreadsheet program to format your address fields for use with our address field type.
- Create an empty column in your spreadsheet.
- Enter a formula in the first cell of that column that concatenates the contents of each of the address columns, separated by two spaces. Most formulas require the spaces to be wrapped in quotes.
- Copy the formula of that first cell throughout the blank column.
- Select the formula column and copy it.
- In a second blank column, right-click to choose Paste Special, and then choose Paste Values.
The first formula column combines the two address columns. The second action duplicates the outputs as values into the second column, which you can use with MailChimp.
When you upload your list to MailChimp, you'll have the option to skip unnecessary columns, so you won't have duplicate individual and combined address fields in your MailChimp list.
You may need to web search for instructions on how to concatenate strings in different applications, including Microsft Excel and Google Sheets. Each is different, and may require a slightly different formula to get the needed outcome.
Google Sheets uses:
Excel and Numbers support:
=CONCATENATE(A2, " ", B2)