Forgot bit locker pin, forgot bit locker recovery key, 5 Easy ways to fix

-
Image
 Did you forgot your bit locker pin and recovery key. Try these methods, I hop it help you. 1. When you see this screen, Press "Esc" key in your keyboard for more recovery option. It will say preparing BitLocker recovery, You will see the screen bellow in few minute. Here we will click on "Skip the drive", You will see the screen bellow. Here you need to Turn off your PC, and then enter the BIOS of your PC. In order to enter BIOS, check for your PC brand and model and search on google, how to enter BIOS for your particular brand and model of your PC. Search for "Secure Boot" Enable it and check it, if it works for you. If it do not work, come back to same place and Disable "Secure Boot" and try again, see if it work for you. 2. If the above method do not work for you, try resetting your PC, You can choose any of the two option for resetting your PC, "Keep my files" or "Remove everything" whichever works for you. 3. If the abov...

How to Transform an Array in a Single Column

-

TOCOL function is used to transform an array into a single column. The TOCOL function lets you rearrange values in 2D cell ranges to a single column. It’s handy for combining data across multiple columns and rows into a single column.

Syntax: TOCOL(array, [ignore], [scan_by_column])

Here, 

·   array : The array or reference to return as a column.

· ignore : [Optional] Use the values listed below to specify whether to ignore certain types of values. By default, no values are ignored.

o    0 : Keep all values (default)

o    1 : Ignore blanks

o    2 : Ignore errors

o    3 : Ignore blanks and errors

·  scan_by_column : [Optional] Scan the array by column. By default, the array is scanned by row. Scanning determines whether the values in the function result are ordered by row or by column.

Suppose you have the following data in cells E1:H6. To convert this data to a single column array, you can use the TOCOL function as follows:

How to Transform an Array in a Single Column

The result will be a dynamic array that consists of the values from the input range, arranged in a single column as shown in the picture.