I am building an import spreadsheet to go into a particular database. The database vendor has a very specific format that the table must be in to work. Here's where I'm having trouble
On a given row, some of the fields contain multiple items, separated by commas. In order for the import to work, these items need to be separated by a line-feed within the cell, instead of a comma. I've tried to illustrate this below.... Any ideas on how to do some kind of find-and-replace that would change the commas to line feeds?
What the table looks like now:
ID | Name | Age | Keyword |
1 | Apple | Pediatric | Red,White,Blue |
2 | Banana | Adult,Teen | Blue,Green,Purple,Brown |
3 | Grape | Pediatric,Teen | Black,White |
What it needs to look like:
ID | Name | Age | Keyword |
1 | Apple | Pediatric | Red White Blue |
2 | Banana | Adult Teen |
Blue Green Purple Brown |
3 | Grape | Pediatric Teen |
Black White |