How to Transpose Data from One Table Column to Another Table Row

Grundwerk D.

Hey, is there a way to transopse data? For exaple to push one cloumn form one table into one row of annother table

8 comments

Grundwerk D.
·
·
*Transpose
Adam R.
·
·
believe that would be the ‘write to table’ feature if im not mistaken
Channeled
APP
·
·
👋 Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!
Grundwerk D.
·
·
Im using right now 5x write to other table next to each other. But it gest a bit anoying to do that. Would be great if you could tell me if its possible to create a List combining different cells to push that list over.
Grundwerk D.
·
·
Nverming, pushed the data to a clay webhook in annother table into a list. But would be still great to know if its possible to create a list myself combining different rows to use tha on wirte to other table.
Bo (.
·
·
Yes, you can create a list yourself! Here’s how: 1. Use a formula to combine all your values and separate them with a comma. 2. Apply the Extract Values from Data enrichment. 3. Choose Custom and use Regex with this pattern: [^,]+ to extract the values. 4. Use Write to Table to transfer that data into a new table. 5. In the new table, apply a formula to remove the quotation marks from the values. Let me know if you need further assistance! 😊
Channeled
APP
·
·
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!
Channeled
APP
·
·
Hi Grundwerk D.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

How to Transpose Data from One Table Column to Another Table Row | Clay