Hi everybody, new here.
I need a macro that takes e.g. every 10 cells from let’s say column A (the length of column A varies from time to time so I don’t have a fix end) and combine the characters from those cells into one string which is comma separated and paste that into a single cell. Ideally the width of the receiving cell/column then should be a bit wider than standard like ~ 100. The width is not so important if that is complicated to do.
Here an example to illustrate:
<tbody>
</tbody>
Any help is appreciated.
Thanks.
I need a macro that takes e.g. every 10 cells from let’s say column A (the length of column A varies from time to time so I don’t have a fix end) and combine the characters from those cells into one string which is comma separated and paste that into a single cell. Ideally the width of the receiving cell/column then should be a bit wider than standard like ~ 100. The width is not so important if that is complicated to do.
Here an example to illustrate:
A | C | D | |
1224 | Chunk 1: | 1224, 2345, 2345, 3452 | |
2345 | Chunk 2: | 5634, 1224, 2345, 2435 | |
2345 | Chunk 3: | and so on | |
3452 | Chunk 4: | and so on | |
5634 | so on | ||
1224 | |||
2345 | |||
2435 | |||
3452 | |||
5634 | |||
1224 | |||
2345 | |||
2345 | |||
3452 | |||
5634 | |||
1224 | |||
2345 | |||
2345 | |||
3452 | |||
5634 | |||
end unknown |
<tbody>
</tbody>
Any help is appreciated.
Thanks.