excel copy and paste...

[Menestrello]

Hi,
how can I easily copy values from this situation
column A
1
2
3
4
5
6
7
8
9
....

to this situation:
columnA - column B - column C
1 2 3
4 5 6
7 8 9
....

Thanks for your help!

 

[zvkmpw]

how can I easily copy values from this situation

column A
1
2
3
4
5
6
7
8
9

to this situation:

columnA - column B - column C
1 2 3
4 5 6
7 8 9

If the number of rows is always the same, here's one way:

With the original data in Sheet1, put this in Sheet2!A1
=INDEX(Sheet1!$A:$A,(ROW()-1)*3+COLUMN())
and copy right for three rows and down as far as needed.

OTOH, if the length of the list varies, try instead
=IF(above_formula="", "", above_formula)
and copy right for three rows and down past the maximum length needed.

Hope this helps getting started.

 

[menestrinaguido]

Il giorno giovedì 25 luglio 2013 02:00:18 UTC+2, zvkmpw ha scritto:

If the number of rows is always the same, here's one way:



With the original data in Sheet1, put this in Sheet2!A1

=INDEX(Sheet1!$A:$A,(ROW()-1)*3+COLUMN())

and copy right for three rows and down as far as needed.



OTOH, if the length of the list varies, try instead

=IF(above_formula="", "", above_formula)

and copy right for three rows and down past the maximum length needed.



Hope this helps getting started.

Thanks, I tried that, but I got an error on the second part of "Sheet1!$A:$A"

So I tried this other suggestion from another user:
in B1: =INDIRECT("R"&REF.ROW(A1)*3-2&"C1";0)
in C1: =INDIRECT("R"&REF.ROW(A1)*3-1&"C1";0)
in D1: =INDIRECT("R"&REF.ROW(A1)*3&"C1";0)
(... WELL i TRANSLATED HER THE FORMULA FROM iTALIAN eXCEL... HOPE IT'S THE SAME

And it worked fine!.

Thanks for your help!