sql - create new column by adding 2 columns values as row in MYSQL -

i have below column , data

id, fn,ln,address  1,p,k,bangalore 2,m,k,chennai 

output should below

id,name,names,address 1, fn,p,bangalore 1,ln,k,bangalore 2,fn,m,chennai 2,ln,k,chennai 

can 1 me how above output in sql-mysql

do union all, 1 select fn rows, , 1 select ln rows:

select id, 'fn' name, fn names, address tablename union select id, 'ln' name, ln names, address tablename  order id, name   -- if required 

optional order by, keep or remove depending on expected order.