I am wanting to quickly and easily move the data/text I have in a list to 1 singular row so the list in green, I want in a singular row as per column C.

Reputation: 1

Excel - How to move multiple data in a column to 1 singular row (preferably seperated by a comma)

I am wanting to quickly and easily move the data/text I have in a list to 1 singular row

Example

so the list in green, I want in a singular row as per column C.

Upvotes: 0

Reputation: 3563

Alternatively, if you have Office 365, TEXTJOIN is your friend:

=TEXTJOIN(", ",,A1:A4)

Upvotes: 1

Reputation: 39

You can use the CONCATENATE function and add commas in quotes in between your desired cells. E.g.

=CONCATENATE(A1;",";A2;",";A3;",";A4)

Upvotes: 0