transforming 1d (1column) into 5d(5column) matrix through copy paste or other

Posted by Curious on Stack Overflow See other posts from Stack Overflow or by Curious
Published on 2010-05-20T04:10:59Z Indexed on 2010/05/20 4:20 UTC
Read the original article Hit count: 179

Filed under:

transform

|

column

|

multiple

|

columns

|

copy-paste

Ex. I want to take the column with 12345..... and order 5 columns across as seen. next 5 numbers in column will be next row. However my code creates a 4 row gap in between each successive row. I dont know what additional logic (possibly if then statement) I can embed into do loop to may make it cleaner. I am new to this, so showing as much sample code to learn the syntax would be most beneficial. thanks in advance.

Below is the Result of my code. VBA code is below result.

1 1 2 3 4 5 2
3
4
5
6 6 7 8 9 10 7
8
9
10
11 11 12 13 14 15 12
13
14
15
16 16 17
17

Sub Working_Code() ' Working_Code Macro

Do ActiveCell.Select Selection.Copy ActiveCell.Offset(0, 5).Select ActiveSheet.Paste ActiveCell.Offset(1, -5).Select

Selection.Copy
ActiveCell.Offset(-1, 6).Select
ActiveSheet.Paste
ActiveCell.Offset(2, -6).Select

Selection.Copy
ActiveCell.Offset(-2, 7).Select
ActiveSheet.Paste
ActiveCell.Offset(3, -7).Select

Selection.Copy
ActiveCell.Offset(-3, 8).Select
ActiveSheet.Paste
ActiveCell.Offset(4, -8).Select

Selection.Copy
ActiveCell.Offset(-4, 9).Select
ActiveSheet.Paste
ActiveCell.Offset(5, -9).Select

Loop Until IsEmpty(ActiveCell.Offset(0, -1))

End Sub

© Stack Overflow or respective owner

Related posts about transform

Do I need to store a generic rotation point/radius for rotating around a point other than the origin for object transforms?

as seen on Game Development - Search for 'Game Development'
I'm having trouble implementing a non-origin point rotation. I have a class Transform that stores each component separately in three 3D vectors for position, scale, and rotation. This is fine for local rotations based on the center of the object. The issue is how do I determine/concatenate non-origin… >>> More
Unity3d: calculate the result of a transform without modifying transform object itself

as seen on Game Development - Search for 'Game Development'
I'm in the following situation: I need to move an object in some way, basically rotating it around its parent local position, or translating it in its parent local space (I know how to do this). The amount of rotation and translation is know at runtime (it depends on several factors, the speed… >>> More
2d movement solution

as seen on Game Development - Search for 'Game Development'
Hi! I'm making a simple top-down tank game on the ipad where the user controls the movement of the tank with the left "joystick" and the rotation of the turret with the right one. I've spent several hours just trying to get it to work decently but now I turn to the pros :) I have two referencial… >>> More
2d tank movement and turret solution

as seen on Game Development - Search for 'Game Development'
Hi! I'm making a simple top-down tank game on the ipad where the user controls the movement of the tank with the left "joystick" and the rotation of the turret with the right one. I've spent several hours just trying to get it to work decently but now I turn to the pros :) I have two referencial… >>> More
Unity3D: How To Smoothly Switch From One Camera To Another

as seen on Game Development - Search for 'Game Development'
The Question is basically self explanatory. I have a scene with many cameras and I'd like to smoothly switch from one to another. I am not looking for a cross fade effect but more to a camera moving and rotating the view in order to reach the next camera point of view and so on. To this end I have… >>> More

Related posts about column

Metro: Introduction to CSS 3 Grid Layout

as seen on Stephen Walter - Search for 'Stephen Walter'
The purpose of this blog post is to provide you with a quick introduction to the new W3C CSS 3 Grid Layout standard. You can use CSS Grid Layout in Metro style applications written with JavaScript to lay out the content of an HTML page. CSS Grid Layout provides you with all of the benefits of using… >>> More
Metro: Introduction to CSS 3 Grid Layout

as seen on Stephen Walter - Search for 'Stephen Walter'
The purpose of this blog post is to provide you with a quick introduction to the new W3C CSS 3 Grid Layout standard. You can use CSS Grid Layout in Metro style applications written with JavaScript to lay out the content of an HTML page. CSS Grid Layout provides you with all of the benefits of using… >>> More
php foreach question

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the following code $oldID=-1; $column=0; foreach($pv->rawData as $data){ if ($oldID!= $data->relativeTypeID){ $oldID= $data->relativeTypeID; $column++; $row=1; } echo "Row: ".$row.": Column: ".$column.": ID".$data->relativeTypeID."<br>";… >>> More
Update table.column with another table.column with common joined column

as seen on Stack Overflow - Search for 'Stack Overflow'
Hit a speed bump, trying to update some column values in my table from another table. This is what is supposed to happen when everything works Correct all the city, state entries in tblWADonations by creating an update statement that moves the zip city from the joined city/state zip field… >>> More
Test Column exists, Add Column, and Update Column

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to write a SQL Server database update script. I want to test for the existence of a column in a table, then if it doesn't exist add the column with a default value, and finally update that column based on the current value of a different column in the same table. I want this script to be… >>> More