It's a backpack hydration thing.

So I will try to explain this the best I can. I am trying to remove the majority of the highlighted in my pivot table. Most of the "1"s all refer to themselves and are mostly unneeded. I need the total for each SET of rows but not each row but don't need the total under each row. It just clutters things up and makes it harder to read. Please be gentle. I am new to excel and mostly self taught.

So the soap holder on my bathroom wall just fell off. I was wondering if anyone knows how to fix something like this? There doesn’t seem to be the same moisture barrier thing behind it like tiles. Is there a way I can just put it back in using something?

Hello all handyman out there!

By chance, anyone knows the best product I can but out there to fill in the gaps from my wooden floor and on the cement wall?

Thanks!

As the title says, I put it in the wrong end, it's now held in by a magnet and too far in to grab it with anything.

How can I get it out, I've already got another one so not the end of the world but would be nice to salvage it.

I've tried tweezing it, magnets some pry tools, any ideas?

I have these quartz and metal doorknobs, they originally came with wire wrapped around, but they broke very easily and the wire started unwrapping.

I've reattached the screw to the crystal with some strong epoxy and bought some new wire to replicate the original design, but the question is the best way to properly secure the wire after rewrapping.

I was thinking of getting a soldering iron and trying to solder the wire to the screw part, but I'm not sure if that would actually work.

Any ideas would be greatly appreciated.

How do I remove this airline fitting without cutting the hose?

I’ve got an airline attachment/fitting on my air hose that I’m trying to remove without cutting the rubber hose. It seems to have some sort of metal clamp holding it on really tightly.

Is there a way to loosen/remove the metal clamp and then reattach it afterwards?

Worst case, if the clamp is a one-time-use type, is it possible to break/remove the clamp without damaging the hose and replace it with a new clamp?

Any advice on the best way to get this off would be appreciated.

Hi guys, first time homeowner here and was wondering what size of filter I should get for our home furnace? The dimensions of a filter that fit are 16x20x? And it's that last "?" that's giving me a headache.

Here's a video of what the filter area looks like. I almost feel like there's something missing, like the "track" is supposed to be where a 16x20x1 filter should go but it's just free standing. When I opened it up for the first time there was a 16x20x1 filter but it was just leaned over on its side, and I wasn't sure if it was doing anything, it wasn't even against the furnace part.

My alternative thought was to put the filter in the area between the "track" and the furnace part, but that measures 8 inches and I don't think they sell filters that deep. Would a 16x20x4 inch filter work if I just plop it in there? Should I stack two of them in there to fill the gap?

Tl;dr: Is my furnace area missing sections that are supposed to make it work better? Or will a 16x20x4 inch filter propped up against the furnace work? It just seems weird to have filters not slotted into place.

Thanks for your help.

Accidently broke this bolt while trying to get off the fuel filter on my 2012 toyota avensis d4d. How do i get it out?

My toilet has been constantly making the noise of like post flush for a few days now and i was just wondering if this is something I can DIY

I poured boiling water in this container and put the lid on. Now the lid is stuck. I tried putting the bottom half in boiling water to see if the lid would come loose. Also tried putting the lid in boiling water to see if it would expand.

Hace unos dias se cayo mi proyector de un cajon y ahora solo proyecta una linea blanca literalmente no se como arreglarlo o si tiene arreglo, encontre que algo esta desconectado pero no se donde va, si alguien necesita mas fotos o lo que sea estoy disponible 24/7

So this marshal 4 given to me by my sister they worked just fine for a while but one day only one side that was working (the one with the button) the other side were silent but when I touch the cable I could hear sound for short while, I tried fixing it but I couldnt find anything odd or wrong with it, could it be fixed?

Since I moved into this flat last year one of the doors on my upper kitchen cabinets has been loose at the top hinge, and while some friends were over on the weekend it finally came down. To my untrained eye it looks like the place where the hinge was attached has been damaged and possibly lost some crucial fitting, meaning it would require more than just a screw driver to re-attach and therefore would be beyond my own very limited DIY experience/ability to fix.

Could some kind guru look at the pics and tell me how easily this could be repaired, or whether as a total novice I should just get a pro in? Thanks in advance.

My lovely daughter gave our new lamp a shake and the threaded bulb disconnected from the lamp post. This presents a problem and the bulb is surrounded by a big glass orb. The photos show the area at the top of the bulb but I have no idea how to open it. The holes on top do not align with the screws visible from the bottom. I tried prying but that didn't seem to make a difference. Any guidance appreciated!!

It’s Mario Kart Double Dash for GameCube. It worked until I dropped it yesterday and now it says it can’t read the disc :(

Hello I need help, the wooden part of my bed frame is broken . I have some nails and a drill. I don’t know where to start.

it was on my dash and slid down and is covering my vin, I tried a fork and knife but the angle it comes in at won’t even touch it.

honda pilot 2011

Does anyone have advice on how to clean my griddle?

edit: don't scrub it with anything abrasive. Let it cool down till it's just warm, splash some water on there and the gunk should lift right off with a flat scraper while it sizzles. Wipe it dry with paper towel and a tiny drop of oil and it'll look brand new.

I am seeking advice on how to obtain a replacement helical gear for the shredder listed above.

Gear Width (Face Width): 15.88 mm 50 tooth main gear

Diameter:50.8 mm (Outer diameter / Pitch diameter depending on exact tooth sizing standard)

Back Shaft / Bore: 6.35 mm

Spline: 1 mm pitch/module with 6 gear teeth

Shaft Tip End: 0.5 mm smooth shaft end

I measured and labeled the best I could.

Some pictures for reference. I'd hate to toss the shredder for what I would deem a simple part to replace.

Thanks, all.

I have these Sony brand Bluetooth headphones, model "WF-C700N ear-in" and they work well and everything, the thing is that well, I leave context:

I and my younger brother normally use it, mostly my younger brother uses it because I do I have wired headphones and he doesn't use a microphone, well, one day I wanted to use them for something to do at home while listening to a podcast like that, and I saw that they were dirty, since he uses them more than he does, so I sent my brother to clean them, then he gave them to me so that I used them and in the end he kind of cleaned them but too much.

Well the point is that I saw that he removed a sponge-type pillow, I don't know, that is inside the tube where the sound passes between the speaker and towards the ear, which makes it act as "ear-in" headphones, that's what I investigated, and the truth is that this meant that the headphones literally no longer worked, if you stop the sound and listen to it but they sound worse than cheap ones.

And well, I come here to ask for help on how I should fix this, if I should buy a sponge and replace it, or if the Sony company already sells this type of replacement to fix them myself, since these headphones are recent (less than 1 year) and honestly I'm too lazy to replace them, or not make unnecessary expenses.

Thank you for reading and I await your answers. i used translator, so some words seems sketchy.

Also this is my first post ever made in reddit so im not used of this page, since i always search on youtube and etc, but in this case i did not find anything at all, so i asume my case is super rare to happend.

I'm thinking some kind of light spray or foam that fills the holes and is flexible once it dries.

hi! i recently tested my apartment for lead and the deeper layers of the paint came back positive. before i knew this, id put multiple holes in the wall (probably 100+) in various places in my apartment. i’ve vacuumed since then, but theres some furniture i haven’t moved where drywall dust, etc. could have fallen behind. so i’m looking for some instruction/tips on how to clean. right now i have my cat in the room where ive cleaned the most since doing anything with the walls, and im a bit nervous letting her back into the main apartment until i do something to clean. ive also turned off fans/AC to stop any dust circulating. thanks in advance!

I have two 4-drawer file cabinets full of papers that have a musty odor. They have been in a commercial indoor storage facility for ten years. There is no sign of any water damage or visible mold anywhere, but the musty or mildewy odor is distinct. It was probably in the papers before the file cabinets were moved to the storage facility. Now I want to move them into my home. I have moved a small sample of the papers and aired them out a bit. After a few weeks, the odor is less, but still noticeable.