Move data from cell to cell

[cabledude39]

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.

 

[Zack Barresse]

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]

I am simple, so I give you a simple formula solution

Put in B1
=+ A2

Put in C1
=+A3

Työkirja1
	A	B	C	D
1	Customer 1	Sales 1	Sales 2
2	Sales 1
3	Sales 2
4	Customer 2	Items 1	Items 2
5	Items 1
6	Items 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