Clay Icon
Join the Community
02 Support

Separate Companies by Industry into Different Tables Easily

Avatar of Pierre L.Pierre L.
·
·

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

1 comment

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    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.