Separate Companies by Industry into Different Tables Easily

Pierre L. · 2025-05-06 08:49:45.839338+00

I’ve a list of companies with a column “Industry” and I want each industry to be moved in a separate table. How can I do it ? I tried copy / paste but it’s not working

To move each industry from your “Industry” column into separate tables without using copy/paste, you can use the Write to Table feature. Here’s how: 1. In your current table, select the column that contains the industry lists. 2. Use the Write to Table action to map each industry (or company by industry) into a new table. 3. For each industry, create a destination table (or select an existing one) and map the relevant data from your source table. 4. The feature allows you to map list data from a column into rows in the new table, so each industry gets its own table with the associated companies. This process automates the splitting and avoids manual copy/paste steps.

Sources: Write to Other Table | Documentation | Clay University Write to Other Table | Documentation | Clay University

1 comment