merge multiple fields into one and keep data

Create three separate but very similar append queries. With criteria in col1, col2 or col3 being "not is null".