I receive up to 25,000 rows of customer data per day and need help figuring out how to transpose some rows to columns and eliminate duplicates. I want to transpose columns G & H based on the identifier in column A. then eliminate blank rows if possible. I included 2 screenshots for reference.
-
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.
Transpose Only Specific Columns & Eliminate Duplicates
- Thread starter kramer100
- Start date
DanteAmor
Well-known Member
- Joined
- Dec 3, 2018
- Messages
- 18,487
- Office Version
- 2019
- Platform
- Windows
the images are not visible.
You could upload a copy of your file to a free site such www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.
You could upload a copy of your file to a free site such www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.
Upvote
0
