Data cleanup: How to combine several columns with slightly different names and non-intersecting data into one?
I have an exported CSV that was formed from two or more different sources that have slightly different column names.No row has data in more than one of those columns. Like on the screenshot below: How do I combine all of them into one column? One idea is to use Combine Columns()
which will result in a Multiple Response column, but since data is non-intersecting, it will be just one number throughou...