Ananthak275
Board Regular
- Joined
- Aug 22, 2020
- Messages
- 128
- Office Version
- 2013
- Platform
- Windows
- MacOS
Hi everyone,
I have the following rows of texts. My data starts on Row 2 (since there is a header). how do i get the unique values? and them pasted below the last row of that column. For example, CityName (Column A) starts in A2 and ends in A7, so i want the unique values to be pasted start on A8. While StateName starts in B2 and ends in B5, so i would want the unique states starting in b6?
I have the following rows of texts. My data starts on Row 2 (since there is a header). how do i get the unique values? and them pasted below the last row of that column. For example, CityName (Column A) starts in A2 and ends in A7, so i want the unique values to be pasted start on A8. While StateName starts in B2 and ends in B5, so i would want the unique states starting in b6?
1 | CityName | StateName | |
2 | Dallas. Houston, Philadelphia | California, Texas | |
3 |
| Pennsylvania, California, Texas | |
4 |
| Arizona, New York | |
5 | Houston, Philadelphia, Austin | New York | |
6 | Austin, New York City, Los Angeles | ||
7 | San Jose | ||
8 |