number layout

[matmich]

I have a column of item numbers and what I need to do is take and assig
only 3 numbers to a column then start w/ next col.

EX

I have
100
101
103
104
105
256
258
369
398
405
506
360

I need
100 104 258 405
101 105 369 360
103 256 398 36

 

[Frank Kabel]

Hi
try the following on a second sheet in cell A1 (assumption: your source
data is on sheet 1 in column A)
=OFFSET('sheet1'!$A$1,ROW()-1 + (COLUMN()-1)*3,0)
and copy down / to the right

 

[Bob Phillips]

Here's a macro to do it

Sub MoveThem()
Dim i As Long, j As Long

j = 1
For i = 4 To Cells(Rows.Count, "A").End(xlUp).Row Step 3
j = j + 1
With Cells(i, "A").Resize(3, 1)
.Copy Destination:=Cells(1, j)
.ClearContents
End With
Next i

End Sub

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[matmich]

frank, I tried your formula but no luck, am I supposed to enter
something in the () for the row and column?? And if so what?

 

[matmich]

Frank,

I GOT IT !

THANK

 

[Frank Kabel]

Hi
no you don't have to enter anything in this brackets. What did not work
for you (wrong results, formula error)?