I'm doing a draft with my friends... There's going to be a pool of players to choose from. I'm breaking the players down into 2 tables, pitchers and fielders.



This is a picture of the excel sheet that i have the players in. But, because some pitchers have more pitches than others, there are empty slots. I heard this is bad database design, but i don't know another way to do it.

*note: i haven't added an ID column to the database yet, i'll also need a teamID column, so the players that have been drafted will not show up.

You might want to create separate tables for every redundant fields, Then link the tables with primary key foreign key relationships.
To help you out, try drawing an ERD diagram first before creating the table.

Example:
1. Players (Player_ID[PK], FirstName, LastName, POS_ID[FK], THR_DI[FK])
2. POS (POS_ID[PK], POS)
3. THR (THR_ID[PK], THR)
3. Stats (Stats_ID[PK], Player_ID[FK], 1P, 1PR, 2P, 2PR, 3P, 3PR, 4P, 4PR, 5P, 5PR)

This example might not be the best, cause I don't have the whole dataset for your database, but i hope you get the idea.