How Stem And Leaf Separator Filter -
2. Click the Separator button that appears, and choose Semicolon. As a result of this step, text from cells B1:B3 are split at each semicolon into columns B–F. 3. Now transpose the data from Rows 1–3 to Columns B–D. Since the data is in multiple rows, you must transpose to a new range (and later delete the initial data range).
More Product