Adding new Rows Using Existing Column Names and Data

you would use tidyr::pivot_longer() to achieve this.
however, I can't demo on your data, as you haven't shared it in a forum friendly way.
If you would like that additional support please see this guide, to see how to create one: