The novel about multiple transmigration where the protagonist finds himself in a dungeon not with the rest of people where he start creating skills until someone goes into the dungeon and rescue him and reach him spear skills or something
I would guess The Legend of Randidly Ghosthound on Royal Road, but it would help, if you could list a few more details. This one is not a transmigration though