Edit Query duplicating rows/turning columns into one

Hey,   I have a question (wasn't really sure how to describe it in subject):   if I have table below   Node                              location ID123, ID143, ID324       Rack01 ID176       ...