Stem and Leaf visualization

Thank you, Farhad.

I can take the first two steps without a hitch but when I try the Pivot Columns function, I get unusual results

I brought in my data, all two digit numbers

I created a cuplicate of the data columns and then split the new column by using 1 as the number characters as the delimiter . That works

I now have three columns : data, stem, leaf

When I pivot the table according to your instructions, line one is fine, line two is fine but then line three returns a two digit number in the leaf column rather than a one digit number in columns three and then four ...

Please review my screenshot to see what is wrong ...

Many thanks again

Duncan