Split a row of data into multiple rows

I have a row of data (numbers) that can be grouped according to ID number. The ID numbers have various numbers of observations from 2-10. I want to sort the row of numbers according to ID number in separate rows. How do I go about doing this? The ID numbers aren't in the row but are labeled in the row above. Thanks

Post an example workbook (the FAQ describes how to), and then it might be a bit clearer what it is that you want to do.

Pete

I've attached an example spreadsheet. Didn't find the example workbook instructions in FAQ