Thread: Copy same content three times, move on one cell

I haven't found anything for this and am not very advanced with Excel but I have to analyze tons of data and copying by hand is introducing errors maybe. So I would like to know how I can tell Excel to copy the content of cell X three times (into cell A, B and C) and then copy the content of cell Y into D, E, F etc etc.
Could someone maybe help me with that? Thanks!

Hi

Request is a bit too generic. Can you attach an example workbook showing your structure, expected output etc. Make sure there is no sensitive data, but that the example does give a good representation of your real situation in terms of position, data structures etc.

rylo

Ok, an example of the problem is attached, I colored it to show what belongs together. Basically I have the right table and need to fill the left table with triplicates according to the cellID.
Thank you!

Hi

Here's one way using formulas. Note that this is built based on your example structure, layout etc.

B3: =IF(MOD(ROW(),3)=0,INDEX(G:G,ROW()/3+2),B2)
Copy across and down as required.

rylo

That is very helpful, thank you. I was trying to get it to work with ROW and ADDRESS and such but never managed. Thanks again!