Plugging in missing data

[HoustonGuy]

I have a result set I've pulled from a flat file like this:

Column1 Column2
Bob 23
66
12
Jim 3
89
Tom 33
21
12
66

Bob is associated with Column2 values 23, 66, and 12. But the data does not come back in that format.

Is there a transform that can fill in Column1 with the associated names in each row?

Result set like this:
Bob 23
Bob 66
Bob 12
Jim 3
Jim 89
Tom 33
Tom 21
Tom 12
Tom 66

My only known fix is to write a cursor.
Thanks

 

[ousoonerjoe]

Yuck... i can't stand files like that (insurance companies are the worst about that). Unfortunately, a cursor was the only way I ever found to correct it.

--------------------------------------------------
“Crash programs fail because they are based on the theory that, with nine women pregnant, you can get a baby a month.” --Wernher von Braun
--------------------------------------------------