Excel macro to create a flat file?

That might not even be a good title. Im not too sure how to even describe what I need to do. I need to have an excel sheet go from example 1 to example 2. Is this possible??? Could be a few thousand lines total. Once I get it flat (linear?) I can manipulate it from there. Thanks in advance!!

Example 1:
John 2300 1/1/2010
John 500 2/12/2011
John 650 2/01/2012

Bob 1000 1/03/2010
Bob 500 1/15/2011

Jill 2500 1/05/2010
Jill (300) 1/15/2011
Jill 1200 1/30/2012
Jill 600 9/30/2012

Sara 1100 2/12/2011
Sara (600) 2/01/2012

Jane 6000 1/30/2010
Jane (500) 2/12/2011
Jane 1300 1/21/2012

Example 2:
John 2300 1/1/2010 500 2/12/2011 650 2/01/2012
Bob 1000 1/03/2010 500 1/15/2011
Jill 2500 1/05/2010 (300) 1/15/2011 1200 1/30/2012 600 9/30/2012
Sara 1100 2/12/2011 (600) 2/01/2012
Jane 6000 1/30/2010 (500) 2/12/2011 1300 1/21/2012

An other method :

Please Login or Register  to view this content.

Awesome John, that works like a charm (changed "Do Until ActiveCell.Row = 30" for the actual range on my details). Thank you so much.

Thank you GC Excel, I will also try that one. ETA... that one only moved the first line. Which line is the one I should update to how many rows I have in the sheet?

Hi,
this line

Please Login or Register  to view this content.

Should be

Please Login or Register  to view this content.

I assume your data started in cell A1.
If you have a different range, you can do :

Please Login or Register  to view this content.