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 lead hands-on Excel, Copilot, and Python workshops for finance, accounting, and operations teams. Explore corporate training or discuss a workshop for your organization.
Learning on your own? Browse courses and membership resources. I don’t provide individual spreadsheet troubleshooting through comments or DMs.