Move data from cell to cell

cabledude39

New Member
Joined
Mar 3, 2003
Messages
48
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.
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Zack Barresse

MrExcel MVP
Joined
Dec 9, 2003
Messages
10,881
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
  3. Web
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
Joined
May 25, 2004
Messages
1,218
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
:eek: :eek:
 

Watch MrExcel Video

Forum statistics

Threads
1,118,530
Messages
5,572,686
Members
412,481
Latest member
nhantam
Top