Excel - Grouping Data

I have an excel file that contains 1 row for every airline ticket number along with 24 cells of data associated to that ticket. The file needs to go from one row per airline ticket to 12 rows for each ticket. Is there a way to do this without using VB?