IS there a way to create a table with the column names being the first row of another table, and all data that follows. The issue is most of my users don’t have their reports laid out the same way, as some have more rights to other column info in our ERP, and when they use the document they may paste their info in different columns, so a main structured table will not work. Also consider many of the users are not excel skilled, and rearranging data columns correctly, converting to CSV for the CSV import Pack has limited to no use in this scenario. API calls are not an option at this time, so pulling and pasting report is only method i can come up with for the project right now i am working on.
IE
Main table
Column 1 Column 2 Column 3 Column4 Customer Part Cost Qty
JimBobs WidgetA $500 500
JaneDoe WidgetB $220 200
New Table Customer Part Qty
JimBobs WidgetA 500
JaneDoe WidgetB 200
hi @Thomas_Barcuch , it seems you want some help with transpose, that is a long standing request I wrote about 3 years ago:
at the end of the blog I suggest a way to solve it, it is quick and outside coda. Maybe I should create a pack one of these weeks to do the transpose job for us in Coda.
Yeah. I am working on a pack right now. It is close, but i think it is timing out. Simple JSON that sets up a formula in a column on the table. The formula is dynamic in that you tell it what row may have your data (thistable.first()) then what row under that column has your data (thisrow) and finally what to look in first row for (“your text string”). It runs for a bit then errors out without a real reason why.
hi @Thomas_Barcuch , it is Friday night here and I don’t have a clear idea yet on how to solve it. In general I try to stay away from coda enhancing packs (since this should be solved inside coda like it solved in google sheets), but sometimes we need to show the way. I hope you figure it out soon. please keep us posted, cheers and good luck. Christiaan