Extract data to next columns

[Puttaswamy]

Col A has below data from a1 to a100. i need to copy repeated data to next cols, i.e. to b col, c col, d col and so on....
1
2
3
4
5
1
2
3
4
5

 

[sudipto3003]

dear friend,

just select your data from A1 to A100, then select towards right side using Shift key (col b, col c, col d,........) and then press CTRL R.

 

[sgmpatnaik]

@Puttaswamy

Welcome to Chandoo.org Forum, Glad you are here

Another method you can use the Offset Function

Say your data in A1:A100 and you want to reflect the same value in another columns then
just type in B1 = OFFSET(A1,0,0) now copy the formula and paste in your required columns from Ex. B1:I100
when ever you change any cell value in the A1:A100 it will automatically reflect in another columns

hope it clear, if any issue please inform

Thanks

SP