My grandad has about 1-3 weeks left to live, need help dealing with this, any advice/personal stories?

hey everyone. my grandad has small cell lung cancer, and has had it for about a year and a half. now, in just a matter of like 2 weeks, he cant walk anymore, cant pee, so we had a catheter put in, has hospice, and gets a new symptom everyday. lately he is calling the sky home. he is confined to his chair and hospital bed. he is at home. my grandparents live with us. me and my mom are the only ones strong enough to be able to lift him up, because now he is complete dead weight. he cant support himself at all anymore, and cant walk, nothing. we have to pick him up and try to get him stable on his feet while still holding him up, just so he can use the bedside potty hospice gave us. lately he keeps telling us im tired i want to go home. and then he points up after we ask where is home and he points up and says thats home. and he's talking to people that have died a long time ago and having conversations with them, and telling us they are waiting for him to go home. he has at the most maybe 2 weeks. he gets worse everyday. he is my BESTFRIEND and the only man that has been stable in my whole life. He never got to see me drive, im thankful that he's here still for my 18th birthday, but we're losing him. my question is, has anybody else been through this like this? i dont need smart-*** answers like yes people have gone through this. this is the hardest thing ive been through in my life, and ive been through some really really hard times. i need advice on this, or any personal stories?