ChetManley
New Member
- Joined
- Dec 9, 2019
- Messages
- 33
- Office Version
- 2010
- Platform
- Windows
Good day everyone,
I am trying to find a solution for a predicament I have, let me provide an example of the table I'm working with:
This is an example of a data extract that I would be able to pull from my database, what I would like to do is, if there is a blank cell in the range G:H I want the data to move right so that columns G and H always have data - I can leave col F as blank if necessary, as an example, looking at row 3:
As you can see the data from F:G moved Right to the range G:H;
My ask is if there is a way to automate this work as I will be dealing with tens of thousands of cases as these.
My thanks in advance,
CM
I am trying to find a solution for a predicament I have, let me provide an example of the table I'm working with:
A | B | C | D | E | F | G | H | I | J | |
1 | Customer Numb | Serial | Customer Name | Address_Line1 | Address_Line2 | Address_Line3 | Address_Line4 | Address_Line5 | Email Address | Telephone |
2 | 1223 | X12UIN | MR JOHN SMITH | FLAT 1 | YELLOW RD | PO BOX 123 | LONDON | UNITED KINGDOM | smith@test.com | 445566879 |
3 | 44321 | LLP133 | MS ELLEN RIPLEY | LV-426 ACHERON | UNIT 321 | NEW YORK | UNITED STATES | ripley@wyc.com | 16598212 | |
4 | 55488999 | XX921O | MR NICK FURY | 33 | PIAZZA SAN MARCO | VENICE | ITALY | fury@avengers.com |
This is an example of a data extract that I would be able to pull from my database, what I would like to do is, if there is a blank cell in the range G:H I want the data to move right so that columns G and H always have data - I can leave col F as blank if necessary, as an example, looking at row 3:
A | B | C | D | E | F | G | H | I | J | |
1 | Customer Numb | Serial | Customer Name | Address_Line1 | Address_Line2 | Address_Line3 | Address_Line4 | Address_Line5 | Email Address | Telephone |
3 | 44321 | LLP133 | MS ELLEN RIPLEY | LV-426 ACHERON | UNIT 321 | NEW YORK | UNITED STATES | ripley@wyc.com | 16598212 |
As you can see the data from F:G moved Right to the range G:H;
My ask is if there is a way to automate this work as I will be dealing with tens of thousands of cases as these.
My thanks in advance,
CM