Open Office - Drop Down w/ Expanding Sub Category

Job ID: 33364374

Budget: $30 – $250 USD

I was following this tutorial
https://www.youtube.com/watch?v=VxReJslyJm8
But it is on excel and does not work in Open Office.

Also, I need the drop-down sub-category in the same cell. so one cell is used for drop-down.
Is this something that can be done & if so, would you like to do it?
NOTE: Not in Design Mode. Needs to be copied multiple times down one column in the each consecutive row.
Thanks
Terry
Related categories: Data Entry Coding Spreadsheets