This is EXACTLY what I was looking for! Specifically the use of Pivot Column(s) and the Min, Max , Do Not Aggregate under Advanced Options. Thanks for explaining it so clearly and with great examples.
Jeff, I too was looking exactly for this. However, I'm stuck. At around 8:50, you right click the newly created column with your [List]s, and select Extract Values. That's not an option for me. It's not in the right click list and if I click it regularly, the query performs a new step "Expanded ColumnName" ... Any feedback/guidance?
Could you share some tips on how you do the same but where you have only two columns of data to work with? In column A there might be multiple email addresses and column B a list of unique email addresses. I am trying to group the unique email addresses together in a cell adjacent to the common email address.
This is such a great solution to a problem I've had so many times. Really well explained too. I'd love to do a similar video on my channel and refer to parts of your video, hope that's ok with you. Are you Geoff, Jeff or someone else?
Halp!!! I have a dataset that shows a list of every single day of the year in column A and then some averages, sums etc in B-L, then M-AD are employee names with the number of cases they worked going down under their name…. I’m trying to make a dashboard and I can’t group figure out how to group the names so I can have just one slicer. Pivot table won’t show me their name unless I have it under column as sum of name…. How can I group and/or transpose my columns in pivot?
This is EXACTLY what I was looking for! Specifically the use of Pivot Column(s) and the Min, Max , Do Not Aggregate under Advanced Options. Thanks for explaining it so clearly and with great examples.
Glad it was helpful :)
This is insane, exactly what I needed and so rare to find. Super well explained. Thank you!
Thanks for your kind note and I'm glad it helped!!
You are the best Jeff!
This is exactly I was looking for. Thanks a bunch!!!
Thank you very much. You were able to explain it well! Please continue making more videos. Thanks again!!!!
Jeff, I too was looking exactly for this. However, I'm stuck. At around 8:50, you right click the newly created column with your [List]s, and select Extract Values. That's not an option for me. It's not in the right click list and if I click it regularly, the query performs a new step "Expanded ColumnName" ... Any feedback/guidance?
An awesome technique!. Thanks for sharing. Thumbs up!!
Thanks Wayne!
This is so helpful, thanks for sharing!
Glad it helped!!
Extremely useful. Thanks!
Thanks :)
Thank you for sharing this! Can you put this into scatter plot graph and showing as staff as a points?
Thanks! very helpful!
Glad it helped :)
Could you share some tips on how you do the same but where you have only two columns of data to work with? In column A there might be multiple email addresses and column B a list of unique email addresses. I am trying to group the unique email addresses together in a cell adjacent to the common email address.
This is such a great solution to a problem I've had so many times. Really well explained too. I'd love to do a similar video on my channel and refer to parts of your video, hope that's ok with you. Are you Geoff, Jeff or someone else?
Yes, that would be just fine, thanks for checking ... and it is Jeff at Excel University :)
@@ExcelU Great, thanks Jeff, it could be a while before I get the video done but if you want a preview my email is on my channel about page.
Excellent, thank you
Is there a way that to set it up that rather than concatenate the values it would generate an extra row. In this case duplicating the 'client' value.
THANK YOU SO MUCH
Glad it helped
Halp!!! I have a dataset that shows a list of every single day of the year in column A and then some averages, sums etc in B-L, then M-AD are employee names with the number of cases they worked going down under their name…. I’m trying to make a dashboard and I can’t group figure out how to group the names so I can have just one slicer. Pivot table won’t show me their name unless I have it under column as sum of name…. How can I group and/or transpose my columns in pivot?
Amazing...
Which Excel sir
Wow!
Thanks :)