- Highlight column A
- Press CTRL + G
- Click Special
- Select Blanks
- Click OK
- Press =
- Press UP Arrow
- Press CTRL + ENTER
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
- Click anywhere within the data table | |
- Hit the key combination Alt - d - p to bring up the Pivot Table Wizard (which is not on the ribbon) | |
- Select "Multiple consolidation ranges" and click Next | |
- Select "I will create the page fields" and click Next | |
- Select your data table (in the example it's A1:E11) and click Next | |
- Select the location and click Next | |
Now you will see a pivot table that looks just like your data table | |
- Click the Pivot table and in the field list uncheck Row and Column (and uncheck any Page Field, if present) | |
- Now select the cell with the single remaining total number and double click it. | |
The result is a new sheet with your data laid out one item per row. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// HTML // | |
<div class="col-md-6"> | |
<div for='typeId' class="form-group"> | |
<label for='typeId' class="control-label" >Type</label> | |
<select class="form-control" name='typeId' id='typeId' onchange='updateModel()' required > | |
<option value=''>Select Type</option> | |
<?php | |
$qry = "SELECT * FROM trailerType ORDER BY name"; | |
if(!$res = $dbc->query($qry)) { |
Script to scan directories and tag (macOS) indicating GoPro telemetry present.
- Exiftool (https://www.sno.phy.queensu.ca/~phil/exiftool/)
- Tag (Brew install tag)
tag -r GPMF $(exiftool -FileName -ext MP4 -if '$GPSPosition =~ / [E,W]/i' -T .) &&tag -a GPMF $(exiftool -FileName -ext MP4 -if '$GPSPosition =~ / [E,W]/i' -T .)