Last week we were asked to merge street address data from two different fields into one because the email campaign software importer that was going to be used only allowed a single street address field.
Microsoft Excel could have done this using a macro but if you don’t have Microsoft Excel or you do and don’t want to write macros (like us), luckily there’s DataWand to the rescue.
We just use DataWand’s ‘Merge columns’ wand, we specify the two fields that we want to merge (e.g. B,C) and hey presto! your preview shows the merged info.
Here’s it in action; before and after: