Below are 2 short videos showing how to separate data and then convert it from columns to rows. This also works if you want to convert rows to columns.

I’m always using this method as it saves me a lot of time – I hope you find it just as useful 🙂

Excel 2007

Excel 2003