RockandGrohl
Well-known Member
- Joined
- Aug 1, 2018
- Messages
- 788
- Office Version
- 2010
- Platform
- Windows
Hello, I have a quandary.
This is my list of Mailer Regions:
So what I'd like is to write a unique list based on the Regions column to another sheet in column AE from 2 downwards, so it would look like:
(Also, when I add a table in this on the bottom of the line, how do I create new lines under the table (below the bottom row) because when I hit enter it just expands the bottom row of the table and I haven't worked it out)
This is my list of Mailer Regions:
Regions |
1, 2, 11 |
12, 11 |
3, 4 |
3, 12 |
27, 20, 30 |
13, 21, 20, 31 |
31, 30, 39, 40 |
38, 40, 41, 50 |
31, 32, 39 |
22, 32 |
32, 41 |
51, 50 |
So what I'd like is to write a unique list based on the Regions column to another sheet in column AE from 2 downwards, so it would look like:
(Also, when I add a table in this on the bottom of the line, how do I create new lines under the table (below the bottom row) because when I hit enter it just expands the bottom row of the table and I haven't worked it out)
Inclusions |
1 |
2 |
3 |
4 |
11 |
12 |
20 |
21 |
And so on |