# Move data from cell to cell

#### cabledude39

##### New Member
I have kind of a weird problem. I have large 6000 row sheet with customer information. The info is listed in 3 row increments so A1, A2, A3 is all the same customer info. I need to get info from A2 and A3 in the same row as A1.

Please let me know if this make sense....and it there is something I can do to properly format the sheet. Thanks.

### Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

#### Zack Barresse

##### MrExcel MVP
Hello cabledude39,

So this three-cell data set repeats down to row 6000? I.e. rows 1, 2 & 3 contain the same customer info, 4, 5 & 6 contain the same customer info, etc? Is the data in these three rows the same or are you looking to combine the data? Check out the link at the bottom of the page for Colo's HTML Maker addin. There is a FAQ in the main Excel forum about information you should know about the addin before posting. A representative sample of 4 or 5 data sets should be sufficient.

#### Pekkavee

##### Well-known Member
I am simple, so I give you a simple formula solution

Put in B1
=+ A2

Put in C1
=+A3
Työkirja1
ABCD
1Customer 1Sales 1Sales 2
2Sales 1
3Sales 2
4Customer 2Items 1Items 2
5Items 1
6Items 2
Taul1

Then copy formulas by dragging them.
When you drag them select B1:C3 as a range.
This leaves two rows empty and copies only formulas.
Target range has to be 3 *rows.

Then use Copy- paste - special - values to get rid of the formulas.

Then sort them by B1 or so and delete what you don't need

Someone has certainly a neat VBA way of doing this.

Pekka

Replies
0
Views
125
Replies
3
Views
105
Replies
4
Views
418
Replies
1
Views
142
Replies
3
Views
79

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,163,806
Messages
5,833,778
Members
430,232
Latest member
Testsubject

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back