W
WannabeExcelQueen
I have data that needs to be moved from column B to C and D
Basically it's set up like below, and I need cell B2 to move to C1, and B3
to move to D1 and so on. There is a space in between sets like this and some
of them have a suite and some do not. So some sets are 4 rows then a blank
space, and some are 3 rows then a blank space.
A B C D
1 First M. Last 123 Street Name
2 Suite 123
3 City, State Zip
4
5 First M. Last 123 Street Name
6 City, State Zip
7
8
What I need is for the Suite to go to C and the CityStateZip to go to D
automatically.
Is there a code or macro I can use to do this without having to move each
row and then delete all the blanks?
Basically it's set up like below, and I need cell B2 to move to C1, and B3
to move to D1 and so on. There is a space in between sets like this and some
of them have a suite and some do not. So some sets are 4 rows then a blank
space, and some are 3 rows then a blank space.
A B C D
1 First M. Last 123 Street Name
2 Suite 123
3 City, State Zip
4
5 First M. Last 123 Street Name
6 City, State Zip
7
8
What I need is for the Suite to go to C and the CityStateZip to go to D
automatically.
Is there a code or macro I can use to do this without having to move each
row and then delete all the blanks?