I have the following scenario: I have 3 columns of data A,B & C. Column A has multiple entries with possible repetitions. Pick each unique value in A and print it's corresponding values from B & C in new sheet or columns. Sample data and expected output is attached!
Thank you in advance ....
Use Pivot Table for the expected outcome
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thanks, but I have large number of entries and I would like to have a holistic view of all the data instead of picking each ID from the drop down! Any further guidance will be well appreciated!
I am not talking about Filter I am suggesting you to use PIVOT TABLE, please don't get confused
Sorry, my bad. Couple of questions: 1> Does the pivot table automatically update as the raw data changes? 2> Does it scale to say 500K+ entries in Excel 2010?
Thanks.
Whenever any change in your RAW DATA come back to PIVOT TABLE and place the cursor inside the PIVOT and do RIGHT CLICK and select REFRESH. The change in RAW DATA will get applied in PIVOT.
I believe, PIVOT is the best method which handles HUGE DATA better than any other methods in excel..............
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks