I’m going to try and make this make sense. I’ve built out 12 different formulas/fields to spit out different date results based on a primary date field and some other factors. I now need to be able to either copy horizontally and paste vertically, or somehow bring them all into one new field that can then be copied and pasted into new records.
Not exactly. I have several different formulas in a table that are different fields across. I want to take those results and put them as new records in another table. The first image above shows the formulas across and the second image is then those results as records a different table. I had to copy each one individually and I’d like to find a way to do it automatically. In excel I can paste transposed. I tried a few different automation but couldn’t get it to work.
This could be done with an automation, though it might be tough. Will the destination records (where the data is to be pasted) always remain the same, or will they change each time this is done? Also, do you need to do this on a specific schedule (e.g. once a week, once a month, etc.), or is it more on an as-needed basis?
@Kelly_Vorrasi1 Thanks for the clarification. What if a script created the new records for you? You do the setup in the one-sheet, then click a button to run a script that makes the new records as you showed above. Would that work for your use case?