Combine two text fields line by line
I want to combine text from two fields on a line by line basis. I have two multiline text fields, call them "Dates" and "Alpha". "Dates" is a column of dates, formatted "MM/DD/YYYY" "Alpha" ...
Forum Discussion
That would not result in the line by line concat as above, based on my experience with excel.
I see no reason why not? You say that the two tables have an equal number of records. So place the two original data field columns side by side, enter the formula in at the head of column three and copy the formula down. Therefore the new field will be generated line by line.