Look Who it Was Random video

converting columnar data to sortable rows

1,192 views · Published 5 June 2013 · 9:18 · Indexed 6 October 2026

Channel: Excel On Fire (Oz du Soleil) · 2013 · Education

Watch on YouTube

This is a common problem:
"I received data that's in a long column but it needs to be in rows that can be sorted."

To get the data arranged properly, we look for patterns. One pattern is that there's a space before every new entry. From there, it's easy. The video shows how to use IF statements the the OFFSET function to get the data the way we need it.

Please comment or ask questions if you need clarification or have a request for other data/Excel challenges.

More from this channel