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.
This issue is that the multiline text for each field value would be in once cell. You would have to bust each multiline text value out into individual cells first to concatenate in the manner you describe.