My solution (under Protel) was to take from BOM only:
- number of elements: 5
- their symbols: R1, R3, R7, R8, R9
- their value: 1k
I copy such BOM to second page of my LibreOffice spreadsheet and all neded values are filled from the first page which is my database of used elements.
That way I have all such informations in one place, see and edit easily.
With KiCad I will also get footprint from BOM. Thanks to that I will have 1k in different footprints (til now I had 1k and 1k_4 elements). I have checked that spredsheet can serch for text being a concatenation of texts from two columns.
People here helped me to modify bom_csv_grouped_by_value_with_fp.py to get what I wonted: