Help With transposing massive data file

I have a massive file of format:
Title 1
Data point 1
Data point 2
Data point 3
......................
Data point n
Title 2
Data point 1
Data point 2
Data point 3
......................
Data point n
........................
...........................
Title n
Data point 1
Data point 2
Data point 3
......................
Data point n

And I need to some how get it to be transposed to:

Title 1	Data 1	Data 2	.....	Data n
Title 2	Data 1	Data 2	.....	Data n
Title n	Data 1	Data 2	.....	Data n

I know about the transpose option on paste, but I would have to go through and do that about 10000 times or so. I really hope I don't have to do that.
I really appreciate any help you can give me!

Well I've already learned something! I have a program called access on my computer! I'll go try and see if that works for me. Thanks!

Unfortunately I get a # Ref with that.

Same layout as Sambo kid...

Formula:

=IFERROR(IF(IFERROR((MATCH("Title "&ROW(),$A$1:$A$20,0)+COLUMNS($B$1:B1)-1)>=MATCH("Title "&ROW()+1,$A$1:$A$20,0),FALSE),"",INDEX($A$1:$A$20,MATCH("Title "&ROW(),$A$1:$A$20,0)+COLUMNS($B$1:B1)-1)),"")

Drag right and down as needed.

May have to be tweaked as I only tested it on a small sample (attached).

Maybe I'm having trouble with the type of data, and should have given you more info. This is a more accurate example.
TCRBV01-01
0.034897
0.239874
0.987363
0.473826
.
.
.
TCRBV01-02
0.023874
0.928374
0.984727
.
.
.
.

I've tried adding "Title " to the titles as such "Title TCRBV01-01" and I tried changing the "Title " term of the equation to "TCR." In both cases still just got blank cells.

Try this...

Formula:

=IFERROR(IF(IFERROR((MATCH("*"&ROW(),$A$1:$A$20,0)+COLUMNS($B$1:B1)-1)>=MATCH("*"&ROW()+1,$A$1:$A$20,0),FALSE),"",INDEX($A$1:$A$20,MATCH("*"&ROW(),$A$1:$A$20,0)+COLUMNS($B$1:B1)-1)),"")

Hum so maybe I'm doing Something wrong but, with jhren's eq I get blank cells and with the The Sambo kid i get zeros