Reformat the weight.csv you get when you download garmin connect weight data

ParseGarminWeightCSV.ps1

# Login to https://connect.garmin.com/ & Navigate to 'Health Stats > Weight > 1 Year' 
# at the top there is an export, that'll get you the csv.
# but the csv is in a poor format, with the date on the row above the data - this will reformat it for you

$weight = import-csv 'C:\Users\JessPomfret\Downloads\Weight.csv'

$counter = 0

$final = $weight.foreach{
    if ( ($counter % 2) -eq 0) {
        $date = $psitem.time.trim()
    } else {
        [PSCustomObject]@{
            'Date'                  = $date
            'Time'                  = $psitem.Time 
            'Weight'                = $psitem.Weight
            'Change'                = $psitem.Change
            'BMI'                   = $psitem.BMI
            'Body Fat'              = $psitem.'Body Fat'
            'Skeletal Muscle Mass'  = $psitem.'Skeletal Muscle Mass'
            'Bone Mass'             = $psitem.'Bone Mass'
            'Body Water'            = $psitem.'Body Water'
            'WeightDate'            = $psitem.WeightDate 
        }
    }
    $counter++
}

$final