This is part of a series of Excel tips focused on helping you clean up your contact data. Today’s tip explains how to combine multiple columns into one.
We’re big fans of making it as easy as possible to import your data into Batchbook. We’ve done things like creating drag and drop import, imports from various integration partners and a handy mapping screen all in the name of helping you get up and running quickly.
Even with all of this, there is occasionally the need for folks to massage their data files in order for the smoothest transition from their old system (whether it’s another service or good ol’ Excel files) to Batchbook. When working with folks on cleaning up their data for import we’ve sometimes come across the need to combine multiple spreadsheet columns into one final column.
For example, we might have a customer who’s trying to import their client’s favorite colors as either tags or as a multi-choice Custom Field Set. In either of those cases we need to get all three columns into one column for easier importing.
Start by identifing which columns to combine
Here’s how the file looks when you start. Notice the three end columns, one for each available color.