Hi,
I have a data feed which merges all the information into one cell. I can
divide the data by using text column but then I will have no ideas which
information does the lines belong to. For example column A contains drug
number and B has the 10 line information I need and there are totally 20
entries. ( The original files are 20 rows)How can I divide this information
into 200 rows and still keep the information match to each other in each line?

Thanks!

CC