A reader had a group of items separated by commas which he wanted to turn into a vertical list. In this video I show how to transform the data using text-to-columns and paste special: transpose.
Analytics & AI for Modern Excel

posted on
A reader had a group of items separated by commas which he wanted to turn into a vertical list. In this video I show how to transform the data using text-to-columns and paste special: transpose.
I don’t provide one-off troubleshooting or custom implementation help via comments or DMs. For structured learning or support, please see the courses and training options listed here.