Duplicate then combine data in columns

[Paulck]

I am trying to first duplicate data in all fields in a column.
Then I need to combine that column with an adjacent column.

| URL | IMG |

https://myurl/images/ | 123.jpg

I have a large set of data to import into a shopping card via CSV file but the data set has only image names, not path. I need to duplicate the column with the url path to image folder than combine each row to append to second column to wind up with one column with full path to individual images.

I really don’t want to have to use copy/paste 500 times.

in past I could highlight and drag and fill a column but now all that happes ( including CTRL+Drag) is it makes one copy of data in the last field I drag to but not in between. I tried copy the select the empty fields and paste but it just says “cannot copy from clipboard”

There must be a better way!!

[Wanderer]

@Paulck

trying to first duplicate data in all fields in a column.
Then I need to combine that column with an adjacent column.

Why not simply use a formula like =A1&B1 in cell C1, copy the formula down the column.
.
After column C looks ok, copy it an paste it back with setting “only values” in C.

[mariosv]

Or using Menu/Data/Calculate/Formula to value, instead of copy - paste.