So I have this problem when importing a csv file, one cell has information that needs to be split into columns or repeated with the same tablet id. I have tried several combinations but everything takes time and it is not clean and it doesnt solve the problem, any ideas data is below and the two outputs are what I am trying to split, thanks!:
<tbody>
</tbody>
RAW | ||||||||
Tablet ID | Placement | s_det | notes | language | date_added | last_update_date | ||
1 | 0 | Elk (3) | English | 11/15/2017 18:52 | 11/15/2017 18:52 | |||
2 | 0 | Elk (1)|Rosemont (4)|Main (15) | English | 11/15/2017 18:55 | 11/15/2017 19:01 | |||
3 | 0 | Elk (23)|Fairgrounds (1) | English | 11/15/2017 18:52 | 11/15/2017 18:33 | |||
4 | 0 | Elk (1)|Rosemont (4)|Main (15)|Fairgrounds (3) | English | 11/15/2017 18:55 | 11/16/2017 20:41 | |||
OUTPUT 1 | ||||||||
Tablet ID | Placement | s_det | Amount | notes | language | date_added | last_update_date | |
1 | 0 | Elk | 3 | English | 11/15/2017 18:52 | 11/15/2017 18:52 | ||
2 | 0 | Elk | 1 | English | 11/15/2017 18:55 | 11/15/2017 19:01 | ||
2 | 0 | Rosemont | 4 | English | 11/15/2017 18:55 | 11/15/2017 19:01 | ||
2 | 0 | Main | 15 | English | 11/15/2017 18:55 | 11/15/2017 19:01 | ||
3 | 0 | Elk | 23 | English | 11/15/2017 18:52 | 11/15/2017 18:33 | ||
3 | 0 | Fairgrounds | 1 | English | 11/15/2017 18:52 | 11/15/2017 18:33 | ||
4 | 0 | Elk | 1 | English | 11/15/2017 18:55 | 11/16/2017 20:41 | ||
4 | 0 | Rosemont | 4 | English | 11/15/2017 18:55 | 11/16/2017 20:41 | ||
4 | 0 | Main | 15 | English | 11/15/2017 18:55 | 11/16/2017 20:41 | ||
4 | 0 | Fairgrounds | 3 | English | 11/15/2017 18:55 | 11/16/2017 20:41 | ||
OUTPUT 2 | ||||||||
Elk | Rosemont | Main | Fairgrounds | |||||
1 | 0 | 3 | English | 11/15/2017 18:52 | ######### | |||
2 | 0 | 1 | 4 | 15 | English | 11/15/2017 18:55 | ######### | |
3 | 0 | 23 | 1 | English | 11/15/2017 18:52 | ######### | ||
4 | 0 | 1 | 4 | 15 | 3 | English | 11/15/2017 18:55 | ######### |
<tbody>
</tbody>