You can leverage Excel’s CONCATENATE function to combine multiple columns together
Example: if you want to merge Column A and column B together in a CSV, you can input this into a cell:
-
- =CONCAT(Cell of Column A Header, “ “ , Cell of Column B Header)
- The “ ” puts a space to separate the two values