PivotTable Text Values Alternative

[@mattirons4909]

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.

[@ExcelU]

Glad it was helpful :)

[@cg24356]

This is insane, exactly what I needed and so rare to find. Super well explained. Thank you!

[@ExcelU]

Thanks for your kind note and I'm glad it helped!!

[@roelpanis8711]

Thank you very much. You were able to explain it well! Please continue making more videos. Thanks again!!!!

[@wayneedmondson1065]

An awesome technique!. Thanks for sharing. Thumbs up!!

[@ExcelU]

Thanks Wayne!

[@nasimak8141]

You are the best Jeff!

[@ladvozer]

This is exactly I was looking for. Thanks a bunch!!!

[@alexrosen8762]

Extremely useful. Thanks!

[@ExcelU]

Thanks :)

[@777tmack]

Thanks! very helpful!

[@ExcelU]

Glad it helped :)

[@yimizhao]

This is so helpful, thanks for sharing!

[@ExcelU]

Glad it helped!!

[@Up4Excel]

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?

[@ExcelU]

Yes, that would be just fine, thanks for checking ... and it is Jeff at Excel University :)

[@Up4Excel]

@@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.

[@rakhilamamenova4176]

Thank you for sharing this! Can you put this into scatter plot graph and showing as staff as a points?

[@violalapalomar9681]

THANK YOU SO MUCH

[@ExcelU]

Glad it helped

[@reneesmith111]

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.

[@tahirhanif9669]

Excellent, thank you

[@Dorv]

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?

[@MrPileggi86]

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.

[@kuchbhisharekaro9575]

Amazing...

[@tee5798]

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?

[@gvinodnair]

Wow!

[@ExcelU]

Thanks :)

[@arunmurugan252]

Which Excel sir