How to copy cells 4 times into next column

[aps]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Could anyone help me with how to copy each cells of one column 4 times into another column.

That is I have some 500 entries in column A and want to automatically generate 2000 of those in Column B by copying each entry 4 times for a custom purpose

Thanks a lot in advance

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Could anyone help me with how to copy each cells of one column 4 times into
another column.

That is I have some 500 entries in column A and want to automatically generate
2000 of those in Column B by copying each entry 4 times for a custom purpose

Thanks a lot in advance

Did you try to copy the cells, then select a destination, and paste, select
another destination and paste again, etc. If this is not what you want,
please explain further.

 

[aps]

Of course I am aware of copy and paste.It is quite tedious when I think of copy pasting it 500 times, because, all these 500 entries are unique entries, and each entry needs to be copied 4 times in the next column. I would want to write some code/formula for doing that.

In Windows, I could accomplish this by writing a piece of VBA code. I am wondering how to do it in Mac.

I hope I am making myself clear

Thank you Bob for your response,

 

[Bob Greenblatt]

Of course I am aware of copy and paste.It is quite tedious when I think of
copy pasting it 500 times, because, all these 500 entries are unique entries,
and each entry needs to be copied 4 times in the next column. I would want to
write some code/formula for doing that.

In Windows, I could accomplish this by writing a piece of VBA code. I am
wondering how to do it in Mac.

I hope I am making myself clear

Thank you Bob for your response,

No you are not making yourself clear. If you want 4 copies of the same 50
cells, you do not have to paste 50 times, only 4 times. Copy all 50 cells
then select the destination and paste. Select the next and paste it again.

 

[aps]

I apologize for not being clear enough

Situation is something similar to this

A B
ZA01 ZA01
AB51 ZA01
CQ97 ZA01
.. ZA01
.. AB51
.. AB51
.. AB51
AB51
CQ97
CQ97
500 unique CQ97
entries CQ97

All the 500 unique entries on some Column A needs to be copied 4 times in some column B

One way of doing it is copying it 4 times and then sorting it.

Was wondering if I could do it by having some code as macros are not record-able in my Excel 2008. This kind of job has to be repeated and hence needs some automation.

Thanks in advance for any suggestions

 

[aps]

oops... the formatting got screwed up in my above reply.

Column A above contains entries like ZA01, AB51, CQ97 and so on.

Column B above contains the entries containing 4 copies of each entry

Column A
ZA01
AB51
CQ97
..
..
..
..
..
500 unique
Entries
Like
these

Column B

ZA01
ZA01
ZA01
ZA01
AB51
AB51
AB51
AB51
CQ97
CQ97
CQ97
CQ97

 

[Bob Greenblatt]

I apologize for not being clear enough

Situation is something similar to this

A B
ZA01 ZA01
AB51 ZA01
CQ97 ZA01
. ZA01

. AB51

. AB51

. AB51

AB51
CQ97
CQ97
500 unique CQ97
entries CQ97

All the 500 unique entries on some Column A needs to be copied 4 times in some
column B

One way of doing it is copying it 4 times and then sorting it.

Was wondering if I could do it by having some code as macros are not
record-able in my Excel 2008. This kind of job has to be repeated and hence
needs some automation.

Thanks in advance for any suggestions

It is still completely unclear to me as to what you have and what you want
to do. Maybe someone else will jump in and help.

 

[Bob Greenblatt]

oops... the formatting got screwed up in my above reply.

Column A above contains entries like ZA01, AB51, CQ97 and so on.

Column B above contains the entries containing 4 copies of each entry

Column A
ZA01
AB51
CQ97
.

.

.

.

.

500 unique
Entries
Like
these

Column B

ZA01
ZA01
ZA01
ZA01
AB51
AB51
AB51
AB51
CQ97
CQ97
CQ97
CQ97

OK, now I see. I still think the fastest way is to copy, paste 4 times and
then sort. Unless you are doing this hundreds of times per day, it's not
worth automating.

 

[aps]

Thank you Bob for your patience .... I very much appreciate your advice