Copy range in loop

In A28:A38 I have list of numbers. Cell A2 is my destination cell. I need a basic code that copies each value in range A28:A38 one after the next into cell A2. How can this be done?

A formula?
Place it in cell A2

Please Login or Register  to view this content.

Example: Takes the values 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11 from cells A28 thru A38 and makes a single string
"1234567891011"

Is that what you want?

Hi rhudgins

Rick's interpretation is different from mine but makes more sense.

My interpretation is this

Please Login or Register  to view this content.

John