I’m not sure if my setup is optimal or not, but I have a form submission sheet which adds information about a specific type wall, floor, window, roof etc.
In the form, you are asked about the measured width of the wall. This column is a number column with the unit in “centimeters”.
I want to make all the cells in the row into one big text so I used “Make Array” to gather all the cells and used “joined list” to convert it to text.
“Make array” excludes the units. Is it possible to create another way where I can gather all the filled in cells in a row and include the units?