Separate data delimited in cells onto different rows
Author: Sean O’Shea - LITIGATION SUPPORT TIP OF THE NIGHT
…Use this technique in Excel to parse out data that is separated with a delimiter inside a single cell on to new rows, with information from adjacent columns repeating on the new rows…
This kind of clear, simple Excel solution to a common LitSupport pain point is exactly what made the old LitSupport Yahoo Group special. No sales pitches. No motivation other than sharing knowledge. I encourage everyone to find ways to share your own hard earned knowledge. It is already on most of your LinkedIn feeds, so will not be sharing it off the site.