Categories
User Help

How to merge multiple columns into two by power query?

There is a table that consists of several pairs of columns. It’s basically the size breakdown of a product and its corresponding quantity. How can I sum up the quantity of the same size and merge them together? Now I use the copy and paste method to gather up all the information in the first […]

Categories
Apple User Help

1 Mac Can’t ping another Mac

I’m trying to connect two Macs running Minecraft over a LAN server but the connection times out. I also tried pinging the host using terminal but it says that it timed out, too. I can ping this one just fine from a different Mac, and the one that I’m trying to connect to the LAN […]

Categories
User Help

How to merge multiple columns into two by power query?

There is a table that consists of several pairs of columns. It’s basically the size breakdown of a product and its corresponding quantity. How can I sum up the quantity of the same size and merge them together? Now I use the copy and paste method to gather up all the information in the first […]

Categories
User Help

Excel – How to delete specific parts of url in new column

I have an excel column that has a list of URLs, I’m attempting to update the existing URLs with a new schema. There are over thousands of ones to update so I am attempting on creating a function that can handle this for me. Here is an example of some of my entries. /online-sales/new-jersey/online/top-selling-items-in-new-jersey.html /retail-sales/new-york/online/top-selling-retail-shops-in-new-york.html […]

Categories
User Help

Charger keeps disconnecting – Windows issue?

My Hp laptop charger keeps disconnecting and reconnecting. After 20 secs, it disconnects, and 5 secs later, it reconnects. I’ve noticed this behavior only when laptop is turned on. Here’s what I tried: Uninstalled battery drivers from Device Manager (worked for about an hour but issue is happening again now) Running in Safe Mode (It […]

Categories
Apple User Help

Preview shows logical page numbers only in thumbnail view

I have been noticing a weird quirk lately in Preview – on Mojave 10.14.6 – when viewing PDFs with logical page numbers (those that start with roman numerals and then switch to Arabic numbers). Preview recognizes that the file starts with logical page numbers but only in the left-hand thumbnail view and not in the […]

Categories
Apple User Help

Odd issue with same name files

I had a lot of junk files in my Desktop directory and i decided to select them all (Option+A) and create a new directory with those files (^+Option+N). I was surprised with a popup saying that i have files with the same name and asking me what to do. I promptly stopped and compared the […]

Categories
Apple User Help

MacBook freezes constantly but not in safe mode

This is a MacBook Pro, 13 inches, from 2016, running Mojave 10.14.3 First I noticed that the mouse moved in a jittery fashion, like if it bounced around the point I wanted it to be instead of simply being there. Then the computer became excessively slow. Opening a new tab to google the problem took […]

Categories
User Help Web Pro

infinite loader with console error on a page will harm SEO [duplicate]

I have a single page application where some of the category and brand pages are infinite load on the screen (those pages are older now no more available) I want to avoid them. should I use 404 not found page? instead of the loader.

Categories
User Help

How to merge multiple columns into two by power query?

There is a table that consists of several pairs of columns. It’s basically the size breakdown of a product and its corresponding quantity. How can I sum up the quantity of the same size and merge them together? Now I use the copy and paste method to gather up all the information in the first […]