title: seperating values from Arributes
body: <p>I have the following data set. I Would like to keep the Part Number, Material, shape and group and transpose the corresponding values in front of it in new columns</p>
  <p><a href="https://i.stack.imgur.com/MfYp2.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/MfYp2.png" alt="enter image description here" /></a></p>
  <p>i am looking to transpose to something like this:</p>
  <p><a href="https://i.stack.imgur.com/CGspg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CGspg.png" alt="enter image description here" /></a></p>
  <p>can someone please help me. i have used melt function but it wont work the way I want to</p>