How to Separate Data into Rows on Clay from Ocean.io List

·

Hi All, new and I have been breaking my head for the past few hours. I have created a list of using ocean.io for companies which are similar to the ones we already know. Yet, clay keep on giving me the data into one cell. How can I expand the information retrieved so that it has a row per company?

3 comments

Channeled
APP
·
·
To expand company information into separate rows, you have two options: 1. Use "Send row for each item in a list" - This feature turns each item in a list into its own row in another table, which is perfect for flattening lists of companies. 2. From Cell details - Click on the cell containing your list of companies, then hover to the right of the list and select "Turn items into rows" from the menu. This will move each company into its own row in another table. Both methods help you transform condensed data into a more expanded format with one company per row.
Sources: Send table data | Documentation | Clay University Manage cell data | Documentation | Clay University Manage cell data | Documentation | Clay University
Marco M.
·
·
https://app.clay.com/workspaces/646215/workbooks/wb_0sy1m9aShnvHHSaMjov/tables/t_0sy1nprK8Fo3aQCb2p6/views/gv_0sy1npsBoRPydDNmurE
Bo (.
·
·
Hey — when all the company data ends up in a single cell, you’ll want to use Send Table Data to break it out into individual rows. Here’s the guide to help you set it up: 📘 Send Table Data Guide 🎥 Video walkthrough
Let me know if you need help applying it to your table.