If there are multiple values in a field, have a way to separate with a comma or different fields

I understand why values are separate by a pipe for a comma delimited file. That makes sense.

But when I'm in the spreadsheet, the pipe is hard to work with. Is there a way so it could maybe be a comma? Or you export as Excel to use a comma? 

Or there is an option in some cases to have separate columns for a set of keywords vs comma separation?


Maybe a few options to separate the data in a report? 

1 comment

Please sign in to leave a comment.