how do I split a first and last name and write to their owne columns?

To split a first and last name into separate columns: 1. Click Add column → Merge columns 2. Select a Data type from the dropdown 3. Write a formula, including any columns you want to add with / For splitting names, you can also use Extract Data From Values to process the data and apply a custom extraction Regex to split the values into separate parts. Once complete, you can send the newly created values to the desired columns. Alternatively, add new columns using Add column and specify the data type for each new column (e.g., Text for first name, Text for last name).

Sources: Table columns | Documentation | Clay University Table columns | Documentation | Clay University Write to Other Table | Documentation | Clay University