Joining and splitting columns

<< Click to Display Table of Contents >>

Navigation:  PerfectTablePlan 6.0.1 > How do I? > Importing >

Joining and splitting 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.

Joining and splitting columns in Excel

You can use the Excel concatenation operation (&) in Excel to join 2 columns. For example:

excel-join

You can use the Text to Columns operation in Excel to split a column.

excel-split

Joining and splitting columns in PerfectTablePlan

To join or split columns in PerfectTablePlan you need to import the guest list and then use the built in join and split functions. Click on the more_button_w button to reveal the buttons.

To split, select on one or more columns you want to split and click on the Split column(s)... button. The split_column_16Split Columns window will appear.

To join, select two to four columns you want to join and click on the Join columns... button. The join_column_16Join Columns window will appear.

join-and-split-w

Select multiple columns using Shift+click or Ctrl+Click.

videoVideo with audio (0:38 minutes)

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.

m_name_per_m_col_join_w

arrow-down

m_name_per_m_col_join_2_w

arrow-down

m_name_per_m_col_join_3_w

See also:

Example import formats