How to Copy Names to a Seating Chart Based on Table Text in Excel
Question details
The user needs to automatically populate a seating chart with guest names based on the table assignments listed in another column.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Organizing an event and assigning guests to tables using a master spreadsheet list.
- Observed behavior
- The user wants an automated formula to extract and display all names assigned to a specific table in a designated area of the seating chart worksheet without copying them manually.
Ensure that your guest list is organized with one column dedicated to guest names and another dedicated to their assigned table names (e.g., 'Table 1'). Verify that the table labels in your dataset exactly match the labels you will use in your formula.
Use the FILTER Function to Automatically Populate Tables
The FILTER function is the most efficient way to extract a list of names matching a specific criterion, such as a table name, and spill them into your seating chart automatically.
Dynamic array formulas like FILTER allow you to write a formula in a single cell that outputs results into multiple adjacent cells. This eliminates the need to manually drag formulas down or use complex array operations.
Navigate to the worksheet or area where you have designed your seating chart. Select the top empty cell under your first table header (e.g., under the title 'Table 1').
Type the formula: =FILTER('guest list'!C14:C103, 'guest list'!J14:J103="Table 1", ""). In this example, 'guest list'!C14:C103 represents the column containing guest names, and 'guest list'!J14:J103 represents the column containing the table assignments.
Press Enter. The application will automatically spill all the guest names assigned to 'Table 1' into the cells immediately below your formula cell.
Copy the formula to the starting cell for your next table. Change the text 'Table 1' in the formula to 'Table 2', 'Table 3', etc., to populate the remaining tables on your seating chart.
Easily Manage Seating Charts with WPS Spreadsheet
WPS Spreadsheet fully supports dynamic array functions like FILTER, making it incredibly simple to organize guest lists and automatically generate dynamic seating charts. It is a powerful, free tool for all your data management needs.
- 1. Open your Guest List in WPS Spreadsheet: Launch WPS Office, open the Spreadsheet module, and load your event planning workbook containing the master guest list.
- 2. Select the Destination Cell: Click on the first empty cell in your seating chart where you want the names for a specific table to begin appearing.
- 3. Apply the FILTER Function: Enter the FILTER formula to extract the names based on the table column, and press Enter to instantly populate your table seating list.

Frequently Asked Questions
What should I do if my formula returns a #SPILL! error?
A #SPILL! error occurs when the cells where the formula intends to output the matching guest names are not empty. Clear any text, formatting, or data in the cells directly below your formula to allow the list to expand properly.
Can I use this method if I have an older version of Excel?
The FILTER function is only available in Microsoft 365, Excel 2021, and newer versions of WPS Office. If you are using an older version, you may need to use a complex combination of INDEX and AGGREGATE functions, or upgrade to a modern suite like WPS Office for free.
How do I sort the guest names alphabetically at each table?
You can wrap the FILTER function inside a SORT function. For example, use =SORT(FILTER(names_range, tables_range="Table 1", "")) to automatically return the matching names in alphabetical order at the table.




