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.
 

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
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:
 
Master Excel Bundle

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.

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top