Hey guys, I have a list that has Part Numbers in Column A and the vendor in Column E. So column E is a list of vendors duplicated multiple times with some spaces in between. Is there a way to grab all of the vendors in column E and create a row that lists them across without duplicates or spaces on Sheet 2? Thanks!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Column to Row without Duplicates
- Thread starter aware073
- Start date
-
- Tags
- column duplicates row transpose
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,171
- Office Version
- 365
- Platform
- Windows
Can be done pretty in a few simple process:
1. Copy column E to Sheet 2
2. Highlight the data in column E, and from the Data menu, select "Remove Duplicates"
3. Highlight the remaining data and do a Copy, then select a blank cell and go to Paste Special -> Transpose.
4. Click OK.
1. Copy column E to Sheet 2
2. Highlight the data in column E, and from the Data menu, select "Remove Duplicates"
3. Highlight the remaining data and do a Copy, then select a blank cell and go to Paste Special -> Transpose.
4. Click OK.
Upvote
0
Similar threads
- Question
- Solved
