Mr_Ragweed
Board Regular
- Joined
- Dec 10, 2012
- Messages
- 74
I'm struggling with what I think should be simple. I'm using excel 2010. I have a data set with many columns, 2 of which i'm interested in. Let's say column A is "Department Name" and the Column B is "Product name". Both columns could change at any time (More depts could be added, and the products are always changing.) What i want to do is extract and pair up the unique values from each. Ex. Find the name of "dept A" and put it in column c (as a header and then find all of the products housed in "dept A" and populate them in that column. Then do the same for "Dept B". Make it a header in Column D with all of its products listed in the same column. There is no duplication of products across dept's. (Ie each product is unique to its dept).
I've tried the code on page 266 of "VBA and Macros:Excel 2010" from the MR Excel Library and it's kind of on the right path but only pulls 1 dept and doesn't put the values in the same column. (I'm aware it's not written for my placement issue).
Really scratching my head here as this seems like an obvious filter that would be used - (all products a customer bought, with each customer being a column, only i'm switching dept for customer).
Thanks in advance! The advice here is great -i gain a bunch of help just through reading/searching other posts.
I've tried the code on page 266 of "VBA and Macros:Excel 2010" from the MR Excel Library and it's kind of on the right path but only pulls 1 dept and doesn't put the values in the same column. (I'm aware it's not written for my placement issue).
Really scratching my head here as this seems like an obvious filter that would be used - (all products a customer bought, with each customer being a column, only i'm switching dept for customer).
Thanks in advance! The advice here is great -i gain a bunch of help just through reading/searching other posts.