Google Sheets – Instead, split a column into multiple columns with TRUE / FALSE values

Here's a very small version of what I want to accomplish but can't figure out exactly what to look for on Google –

Column A | Column B
Alice    |  Present
Bob      |  Absent

Should translate into –

          Present    Absent
Alice      True
Bob                   True

So basically every unique value in column B should become a new column and the intersection of the row and column should be True.

Further expansion –
It's more complicated, but is that achievable? –

Convert this –

Column A |  HashTag 1 | HashTag 2 | HashTag 3
Alice    |   corona   | staySafe  | 
Bob      |   lucky    | corona    |  blessed  

to

          corona    staySafe   lucky   blessed 
Alice      True       True
Bob        True                 True    True

Here all HashTag columns have the same weight, but each tag is in a different column.

Thank you in advance.

How do I copy corrupted data partitions from unlocked Google Pixel?

I have a Google Pixel (Sailfilsh) device that complains about corrupted data partitions when booting. It is only offered to restart (the same thing happens again) or to delete the data.

I haven't unlocked the boot loader yet, so trying to start TWRP fails. I am currently unable to unlock the boot loader as this would delete the data partition.

I can boot into recovery mode, but the options available there look useless on the interface.

Given that I know the encryption passcode (numerically), is there a way to transfer a data partition to a computer via USB? How?

(I'm mainly interested in restoring photos that weren't backed up at the time the data partition was damaged.)

Google Cloud Platform – Is it possible to get the result of an operation Speech to Text Recognition based on its ID (Python)?

I am trying to get the response to a successfully executed long_running_recognize request (Speech_v1p1beta1) using its ID.
I know how to do this job from the console using the SDK

gcloud ml speech operations wait 

But I can't find a right way to do this with Python. All my attempts to solve the problem have so far been unsuccessful.
Any help is greatly appreciated.

Why can typing in the Google Sheets formula field write over text from time to time as if the "Insert Keyboard" feature was enabled when it isn't?

In the past few weeks, while working on different worksheets on different desktop computers, I have noticed that when entering the formula field, the text is randomly overwritten at about 10% of the keystrokes, as if the insert key had been briefly switched on. Can't find out why. Thanks a lot

Google Sheets – App Script to Random Range with 10% of the total data

I have a table with 20 rows of data.
I want to randomize the data to 10% of the total data.
The script I made is as follows:

function shuffleSheet() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getActiveSheet();
  var range = sheet.getRange('A2:D21');
  range.setValues(shuffleArray(range.getValues()));    
}    

function shuffleArray(array) {
  var i, j, temp;
  for (i = array.length - 1; i > 0; i--) {
    j = Math.floor(Math.random() * (i + 1));
    temp = array(i);
    array(i) = array(j);
    array(j) = temp;
  }
  return array;
}

After I run the script, the data is randomized all the data.
Enter the image description here

The result of what I want can see it below:
Enter the image description here