Hello,
I'm new to Airtable, and I had a question about how I can go about the following process:
I have a table in my base that has a research participant's name for each row, and each name has 4 CSV files of measurements attached to it. All 4 of these CSV files have the same types of measurements for each participant. Ideally, I would like to compile all of these CSV files into a table (either in the same table or a different one) where there is a participant name for each row, followed by all of their measurements. That way, I will be able to run statistics based on this data.
Does anyone know of a good way to go about this? I've tried some things with the CSV Import Extension, but it seems that importing CSV files from the original table into a new one isn't supported.
Thank you!