To consolidate database files:

DBCC SHRINKFILE(‘logicalFileName’, EMPTYFILE);
ALTER DATABASE databaseName REMOVE FILE logicalFileName;