Reputation
Next privilege 200 Rep.
See reduced ads
Badges
1 3 15
Impact
~33k people reached

  • 0 posts edited
  • 0 helpful flags
  • 6 votes cast
Oct
5
comment How do I stack multiple columns into one?
Thanks for introducing me to Power Query. As in my other post this will also work. I am not as worried about requirement #3 since Power Query, I found out, has an alternative way of accomplishing the same thing. If you submit your response as an answer I will accept it.
Oct
5
accepted Need unique count of text from multiple columns by category
Oct
5
comment Need unique count of text from multiple columns by category
It was as easy as emailing the file to someone who already has Power Query add-in installed. BTW Power Query was very easy to install (only took a couple of minutes). +1 for introducing me to tool that not only solved this problem but will solve another similar issue. I see myself using this tool a lot in the near future. I would give you +2 if I could. Thanks again!
Oct
5
accepted Calculating Annualized Turnover in a Pivot Table or PowerPivot
Oct
5
comment Need unique count of text from multiple columns by category
I have been playing with Power query a bit this morning to see if this will really suite my needs. So far it seems that it will. I am just trying to figure out if sharing a .xlsx with Power queries is as easy as sending the file. Obviously whomever I share with will have to have the Power Query add-in.
Oct
5
comment Need unique count of text from multiple columns by category
This is a great solution! I heard of Power Pivot (not a serious user, played w/ it a bit before) but not Power Query. At first I thought this was going to be a more sophisticated SQL editor then MS query which would have been great as well since I am well versed in SQL. But this is way better!
Oct
5
comment Need unique count of text from multiple columns by category
@wbeard I don't understand how your proposed solution would give me the result I am looking for. For example the last three rows would end up as: zooyup, doehgg, doe which would give me 3 when the result is 4 (refer to my response to MichaelFrank).
Oct
5
comment Need unique count of text from multiple columns by category
@MichaelFrank For Cats the 4 unique labels are: zoo, yup, doe, hgg. Dogs is 2 not because there are two rows with Dog (that's coincidence) but because the two unique labels are: doe and zoo.
Oct
5
comment Need unique count of text from multiple columns by category
@DavidDai Today I can accomplish what I need by manually stacking all Label columns (+category repeats in separate column) then inserting a pivot table on that data set (Category and Label in rows) then copying and pasting that and inserting another pivot table on that to get unique labels by Category. I'm looking to make my process easier since it's something I do often.
Oct
2
asked Need unique count of text from multiple columns by category
Oct
2
asked How do I stack multiple columns into one?
May
12
awarded  Notable Question
Mar
20
awarded  Notable Question
Dec
17
awarded  Famous Question
Oct
21
awarded  Popular Question
Sep
24
awarded  Autobiographer
Sep
8
awarded  Popular Question
Sep
5
awarded  Popular Question
Jan
6
accepted PowerPivot Bar is grayed out
Dec
20
answered PowerPivot Bar is grayed out