I am looking to create a macro that can copy text from several different rows, then paste it as a continuous string of data in a single cell using commas to separate it. For example:

How the data looks.
Row 1: A
Row 2: B
Row 3: C
Row 4: D

How I want the macro to copy and paste in a single cell

A, B, C, D


Thanks in advance for all the help!