Add rows based on columns

Hi, I have a table looks like this: There are 6 extra columns indicating different customer IDs and locations under the same user. What I would like to achieve is to spit these 6 columns...