I have a dataset in a worksheet 

```
A1 | Cost | B1 | Cost | C1| Cost
A2 | Cost | B2 | Cost | C2| Cost
...

```

I would like to move these to one column like so:

```
A1 | Cost
B1 | Cost
C1 | Cost
A2 | Cost
B2 | Cost
...

```

I have looked around but I am not really good at VBA, which is what I assume would be best to use. I have to do that 100+ times and the tables are large, and will likely have to replicate it often enough that making something would be useful and save me days of work.

Not sure really where to start. I tried the macro recording but the paste offset overwrites the previous paste because the row offset is on the current row not the last row of the destination.

Here is a sample of my dataset. Trying to get from Blue to Yellow - or take one set from each column set add to Yellow column set then next row and repeat till there is no more in the first column set

[click for image](https://i.stack.imgur.com/ThDZm.png)