I have a column of products (loan sales, fixed income, credit derivatives, etc). Each product is assigned to a specific client in the adjacent column. I need to move each product along that row to a new column with the same heading as the product.
I have been doing this manually and have attached a small sample of what I have done and need to do, but there are about 3000 total values and I am on a deadline.
Have got it figured out, thanks!!!
Last edited by AnthonyAbbate; 06-22-2011 at 11:16 AM.
hi, Anthony,
1. As far as I understand rows 2:81 show the result and everything below is the original data to work with.
2. Can the product quantity change or it's constant?
Last edited by watersev; 06-22-2011 at 10:42 AM.
It is constant, however, I have figured out a way to do it using auto filter and dragging the appropriate values down.Originally Posted by watersev
Thank you for the quick response!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks