Spreadsheet: 767468d1644492316-power-query-transforming-and-organizing-very-messy-data-need-help-guidance-bds_example_powquery
Sheet: Brew Data B1 (Hot Side)

Brew Data Sheet Hot Side
Beer: | Beer name B1 |  | Date: |  | 2022-02-08 00:00:00 |  | [NAME]: | FV-100-1 | Brewers: |  | Name 1, Name 2, Name 3
Grains/Sugar: |  |  | Lbs |  | Variomill / Mash Tun
Company | Malt | Location |  |  | [NAME] In |  |  | 02:30:00 | [NAME] |  | 08:45:00 | 1st Rest Temp. | 150
Company 1 | Malt 1 | Silo 1 | 1000 |  | End Mash In |  |  | 02:45:00 | End Mash Rest |  | 09:45:00 | 2nd Rest Temp. | 170
Company 2 | Malt 2 | Super Sack | 165 |  | Total Time |  |  |  | Total Time |  |  | 3rd Rest Temp.
Company 3 | Malt 3 |  | 125 |  | [NAME] |  |  | 151.5 | Mash pH |  | 5.32 | 4th Rest Temp.
Company 4 | Malt 4 |  | 600 |  | [NAME] |  |  | 164.2 | Mash Volume |  | 92 | 5th Rest Temp.
Company 5 | Malt 5 |  | 250 |  | [NAME]: |  |  |  |  | [NAME]: |  | 0
 |  |  |  |  | 17.5-17.6-17.0-16.5 |  |  |  |  | Lower Feed Roller: |  | 75
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME] |  |  | 10:00:00 | [NAME] |  | 11:17:00 | First pH | 5.32
Total Grains: |  |  |  |  | Vorlauf Finish |  |  | 10:17:00 | [NAME]. |  | 120 | First Gravity | 1.021
Miscellaneous |  |  | Units |  | Total Vorlauf |  |  |  | [NAME] |  | 55 | Final pH | 5.35
Mineral 1 |  |  | 10 | oz | [NAME] |  |  | 10:17:00 | Post [NAME]. |  |  | Final Gravity | 1.095
Mineral 2 |  |  | 20 | oz | Wort Kettle
Mineral 3 |  |  | 30 | oz | Hot Side Hopping |  |  |  |  |  |  | Boil Start | 12:00:00
Mineral 4 |  |  | 40 | oz | Variety |  |  | Pounds | Supplier |  | Time | 1st Addition | 12:05:00
Mineral 5 |  |  | 1000 | mL | Hop 1 |  |  | 100 | Company 1 |  | 60 | 2nd Addition
Mineral 6 |  |  | 100 | g |  |  |  |  |  |  |  | 3rd Addition
Mineral 7 |  |  | 10 | oz |  |  |  |  |  |  |  | 4th Addition
Mineral 8 |  |  | 8 | oz |  |  |  |  |  |  |  | 5th Addition
 |  |  |  | oz |  |  |  |  |  |  |  | Boil End | 15:00:00
 |  |  |  |  |  |  |  |  |  |  |  | Whirlpool Vol. | 126
 |  |  |  |  |  |  |  |  |  |  |  | Knock Out End | 17:00:00
Yeast Propogation |  |  |  |  |  |  |  |  |  |  | [NAME]
Location |  | Gravity | pH |  | Amount |  | Yeast Strain: |  | Brit V |  | Oxygen Tank Pressure: |  | 6
 |  |  |  |  |  |  | Amount: | Print Yeast Calc Sheet |  |  | [NAME]: |  | 0.21
 |  |  |  |  |  |  | Generation: |  | 7th |  | Beverly Unit Avg. Reading: |  | 87.5
 |  |  |  |  |  |  | Glycol Schedule: |  | Pale #2 |  | ALDC - Amount (mL):
 |  |  |  |  |  |  | Pitching Temp: |  |  |  | ALDC in @ KO Confirmation:
 |  |  |  |  |  |  | Fermentation Temp:
[NAME] |  |  |  |  |  |  |  |  |  |  | Date | Spec. Gravity | pH
Positive Volume |  |  |  |  |  |  | Date | Source |  | Initial |  | 1.056 | 5.29
Knockout |  |  | 97 |  |  | bbls |  | BH |  | [NAME]
 |  |  |  |  |  | bbls
 |  |  |  |  |  | bbls
 |  |  |  |  |  | bbls
 |  |  |  |  |  | bbls
Total Positive |  |  |  |  |  | bbls
Negative Volume |  |  |  |  |  |  | Date | Destination |  | Initial | ABV-
 |  |  |  |  |  | bbls |  |  |  |  | Target Numbers
 |  |  |  |  |  | bbls |  |  |  |  | Target pH: |  | 5.3
 |  |  |  |  |  | bbls |  |  |  |  | Target Gravity: |  | 1.156
Total Negative |  |  |  |  |  | bbls |  |  |  |  | Target O2 (ppm): |  | 36
Notes: