Edit Query duplicating rows/turning columns into one

[mgirou]

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                              Rack01

ID943, ID457                  Rack02

How would I, in Query Editor re-arrange the table so that the output is:

Node                              location

ID123                             Rack01

ID143                             Rack01

ID324                             Rack01

ID176                             Rack01

ID943                            Rack02

ID457                            Rack02

Thanks

[jthomson · Accepted solution]

Split the column by the delimiter then unpivot