If there are not too many such entries, you can obtain it like this 

=A2&"','"&A3&"','"&A4&"','"&A5&"','"&A6&"','"&A7