Forum Discussion
Row with an empty cell, find another row with the same name but with that cell and copy the value
I am using rows with two types of information: devices and the serial numbers of those devices, both have same name in first column. Here is an example: Device name Device QR Serial QR Devic...
ronrsnfld
Super User
Super UserIn the Power Query editor, assuming the blank cells in DeviceQR are null, just select that column and "Fill Down". If the blanks are null strings, then replace them with null first.