I am looking for a vba code that will create a new row for each value to the right of data in a column and also concatenate certain fields. I will ultimately be saving this data in csv format so that a program can read the data, so the format is very important. I listed an example below in csv format. any help on this would be greatly apperciated.
Thank you,
Joshua

CURRENT FORMAT
Username,Access1,Access2,Access3,
John Doe,Yes,Yes,Yes,
Jane Doe,no ,no ,no,

DESIRED FORMAT
John doe,Access1 Yes,
John Doe,Access2 Yes,
John doe,Access3 Yes,
Jane Doe,Access1 no,
Jane Doe,Access2 no,
Jane Doe,Access3 no,