Google Sheet Query returns the first three lines of a line

I did a simple query combining data from 4 separate sheets:
= Query ({# 1.MA) # A13: O200; # 2.PF # A13: O200; # 3.BM # A13: O200; & # 39; # 39; 4.C #! A13: O200}, "Select * where Col2 is not null")

The goal is to have all the data in the leaves in which Colum B is filled. This works for the majority except the first three lines in the first sheet. The query returns them combined in one line.
All sheets are exactly the same, the error is not reproduced in the first 3 lines of the other sheets.

Update multiple Google Calendars with a new schedule

Currently I have 3 Google calendars that I keep track of.

I'd like to share the information with all three people so that they can see my availability (and track that availability when I update the calendars). However, I currently have to give them access to all three calendars.

In order to be able to accurately reflect my availability, you must also ensure that they view all three of my calendars when they look at my schedule.

Is there a way in Google at the moment to merge all three calendars and make sure they are always up to date when I open a new appointment in one of the three? The advantage of this is that the person I am sending the calendars has to keep track of only one calendar with all my availability. I can import one calendar into another, but using the file method, it seems that things will not be updated when I do this.

I'm open to creating a fourth calendar just to share it with them, but the update issue will recur if I just import all my events.

Totally Missing from Google.

Hey guys ……… happy that i found this forum !!

I hired a few people from India to help with my search engine optimization, but it does not work.

My website contains stock trading software and has been on the internet for about 18 years.

When I enter "stock trading software" in Google / Bing, my website does not even appear …… and it returns 400 results.

Wondered me why ….. and how I can fix it ……

Does not necessarily have to be number one … lol … but maybe number 40 would really help.

Thanks in advance for advice / help …….


PS. The search for DDAmanda leads to number 1 …… but that is not very helpful ….


Why is not WhatsApp encrypting Google Drive backups?

WhatsApp has end-to-end encryption that promises users privacy.

However, it becomes useless if backups are unencrypted in Google Drive. Our supposedly private data go to the control of Google.

No problem, I can disable the backup. But what about all the people I talk to? Google still knows all my conversations.

This seems to be a useless / fraudulent / lying design designed to ensure that they retain control over the users.

I understand that as soon as I send a message to another person, I can take these screenshots, show them to other people, etc. I understand this risk.
However, this will only be achieved by not encrypting backups path easier for the news to be even more exposed.

The question is: I'm sure that WhatsApp can encrypt backups for Google at will (eg users need a passphrase or at least have this option and recommend users to use it). Why is not WhatsApp doing that?

Messages and media backed up in Google Drive are not protected by WhatsApp end-to-end encryption.

The Android device has logged out of all Google accounts and asked me to sign me in again

That happened to me recently and I have never seen it before. I was wondering why this is and whether that is usual.

I have logged into all my accounts so I can not remember the exact wording of the messages. Therefore I could not search for the exact error message.

I have not logged out anywhere else (for example, my Gmail tabs on my computer)

I'm on Android P, if that's important. The last update of my phone was a week ago. I think that should not have affected things.

Graph two lines in Google Sheets based on the values ​​in the first column

I am trying to create two lines in the same diagram, where a "line A" is based on data named "A" and "line B" based on B.

The x-axis is the date and will be extended over time as more entries are added. The weight would be the Y-axis.

I can not seem to convince Google Sheets to divide the data into two lines based on the "Name" column. Any help would be appreciated. πŸ™‚

An example of data that I want to plot graphically with two lines

Auto Complete – WP Job Manager automatically populates the Google location field

I want to make job_location array with Google Auto Complete.

& # 39; # 39 & job_location; => array (
& # 39; label & # 39; => __ ('place', 'wp-job-manager'),
& # 39; description & # 39; => __ (leave this field blank if the location is not important & # 39 ;, & # 39; wp-job-manager & # 39;),
& # 39; type & # 39; => & # 39; text & # 39 ;,
& # 39; required & # 39; => false,
& # 39; placeholder & # 39; => __ (eg, & # 39; London & # 39 ;, & # 39; wp-job-manager & # 39;),
& # 39; priority & # 39; => 2,

How can I do that when I use the & # 39; type & # 39; => & # 39; text & # 39; in & # 39; type & # 39; => & # 39; autocomplete & # 39; change? then the input via google auto complete address?

Google Structured Data Reviews without SEO penalties

I implemented structured data on my company website when I found this guide:

Well, there is one point that bothers me … "Note that reviews or reviews that are not from actual users are considered spam".

I found references like these or the worst (SEO punishment etc) about fake reviews. Well, my question is, how can Google know if a rating is fair or not?

We had our own rating system where users can post and rate posts. We can also submit Google reviews (but it will be a mix of both sources).

Now I'm a bit worried about how to handle it, as there is no information on how Google can make sure your ratings are related to content.

If I post my own reviews (how do we do it because Google is Google and our website is our website), could Google "ban" our structured data or, at worst, penalize SEO positioning?

Apart from the reviews themselves, there is an overall rating with the best and worst prices, the number of ratings and the average. Could it be interpreted as wrong or fair?

There is little information on these details that we would at first consider all of them as important to me.

Many Thanks