Navigation: How do I? > Importing >
Join and split columns
PerfectTablePlan can handle many different import formats for guest lists. But sometimes you might need to join or split columns in your guest list to get it into the correct format for importing. You can do this either in a spreadsheet before you import or using PerfectTablePlan join and split operations after you import.
You can use the Excel concatenation operation (&) in Excel to join 2 columns. For example:
You can use the Text to Columns operation in Excel to split a column.
Select multiple columns using Shift+click or Ctrl+Click.
Note Join and split create new columns. They don't change existing columns.
For example, you can use the Join feature to convert names in two columns into a single column.