Transpose data from a column in one table to another table in a row

Ask for Help
4
  • Use a Make Array column to create an array from the columns in Table 1 that you’re interested in.
  • Pull that column into Table 2 (there are several ways to do this, which is best depends on exact use case)
  • Add enough rows to Table 2 to cover the total number of items in the array
  • Add a RowIndex to Table 2 (see here)
  • Add a Single Value column. Target the Array column, and select N from Start, where N is the RowIndex.
2 Likes