Transpose data to new worksheet with for loop

Hello,
I am new to creating Macros and need some major help. I have an Excel 2010 sheet with a large amount of data where all of the data is in a single column (A). I am needing to format it so that each data set is in its own row (and in different columns, of course). I assume I need to use a for loop, because not all data sets will have the same number of columns, using "Name:" as the indicator to start a new row.

Thank you in advance for any and all help with this!