Combining 3-4 fields into one new field
Hi, I am in the process of cleaning data in my database. I would like to create a new field that pulls information from 3-4 other fields that all have related information. The reason for this is because these 3-4 other fields ask the same question but the users of the database did not fill them in consistently. Would I need a calculation field for this, and if so how would I go about creating it?
There are a variety of calculations that might work for that.
Substitute ( List ( Field1 ; field2 ; field3 ; field4 ) ; ¶ ; " " )
is one possibility. It will combine the data from each field in a single row separated by spaces but not insert unneeded spaces between fields that are empty.