juleskaynel
New Member
- Joined
- Mar 14, 2014
- Messages
- 9
Hi there, I am looking for a solution, maybe someone can help.
We have several lines of data and right now everything is in the same row. As you can see in one of the cells, there are multiple part #'s in the same cell. Because of this, I can't do a vlookup to add the status of each of these part #'s in another cell. I can manually split this out and then merge the rows before and after this cell. However, that's a lengthy process. Any suggestions on how I can do that quickly?
We have several lines of data and right now everything is in the same row. As you can see in one of the cells, there are multiple part #'s in the same cell. Because of this, I can't do a vlookup to add the status of each of these part #'s in another cell. I can manually split this out and then merge the rows before and after this cell. However, that's a lengthy process. Any suggestions on how I can do that quickly?