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.
Bring this learning to your team
I help finance, accounting, and operations teams put AI and modern Excel to work through ongoing AI and Copilot enablement and focused team workshops. Discuss the support your team needs. Learning on your own? Browse courses and membership resources. I don’t provide individual spreadsheet troubleshooting through comments or DMs.