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.
This site uses Akismet to reduce spam. Learn how your comment data is processed.
Leave a Reply