text to column or mid/find nesting

[Deinoc]

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!:

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>

 

[vanthinh3101]

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!:

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>

Can you post your sample CSV file?

 

[Macropod]

This is a duplicate of: https://www.mrexcel.com/forum/excel-questions/1032726-dealing-macros-mid-find-text-column.html

Kindly read Mr Excel's policy in Rule 12 against asking questions about the same topic in multiple threads: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

Thread closed. You may continue the discussion in your other thread.