Understand the BOQ levels
In the Cleaned BOQ (right side), Level 0 is the item description, and Level 1 to Level 4 hold the headings above it. If a heading was not picked up (for example because of a blank row), you can fill it in yourself.
Tip: Keep your BOQ to a maximum of 4 levels.
Copy the heading
In the Original workbook (left side), select the heading cell you need and press Ctrl+C.
Paste it into the first row
In the Cleaned BOQ, click the level cell of the first row and press Ctrl+V.
Select the rows to fill
Keep the first cell selected, hold Shift and click the last cell of the range.
Fill down
Click Fill down in the Quick Fix group, or press Ctrl+E.
Check the result
The first value is copied down to all selected rows.
How to Fill a BOQ Level Down to Multiple Rows?
Complete missing headings in the cleaned BOQ
Guide 13 of 36 in Baseline creating
