How to fill blanks between column and row

Hi FloydTx- Try this in B2 ( copy across and down):
=IF(ROWS($A$1:A1) < COLUMNS($A$1:A1),B$1,$A2)

Row\Col	A	B	C	D	E
1	Ben	Dan	Ike	Tim	Jon
2	Dan	Dan	Ike	Tim	Jon
3	Ike	Ike	Ike	Tim	Jon
4	Tim	Tim	Tim	Tim	Jon
5	Jon	Jon	Jon	Jon	Jon

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

Thank you so much for the help. Works great.

One last question, similar topic.

If I have data that originally looked like this ( "|" <-- indicates new cell and "." are just empty space... ignore. Put in to make the pic more accurate):


Ben | Baseball | 3
Ben | Football | 4
Ben | Soccer | 3
Ben | Softball | 1
Rob | Baseball | 3
Rob | Archery | 6

I need it to look like this:
........| Baseball | Football | Soccer | Softball | Archery
Ben...|....3.......|......4......|....3.....|.....1.....|.............|
Rob...|.....3......|..............|..........|.............|.....6......|

Any ideas?

Something like this? Formula in G2,copy across and down:

=SUMIFS($C$1:$C$6,$A$1:$A$6,$F2,$B$1:$B$6,G$1)

Row\Col	A	B	C	D	E	F	G	H	I	J	K
1	Ben	Baseball	3				Baseball	Football	Soccer	Softball	Archery
2	Ben	Football	4			Ben	3	4	3	1	0
3	Ben	Soccer	3			Rob	3	0	0	0	0
4	Ben	Softball	1
5	Rob	Baseball	3
6	Rob	Archery	6

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee