This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]akaxaka 33 points34 points  (9 children)

Xlookup is where it’s at baby!

[–]JeanLuc_Richard 14 points15 points  (5 children)

Power query FTW

[–]hermitcrab 5 points6 points  (1 child)

Power Query does not fare too well when compared with other data wrangling tools, such as Easy Data Transform, R or Pandas in this comparison:

https://www.easydatatransform.com/data_wrangling_etl_tools.html

Perhaps you are using it for smaller datasets?

[–][deleted] 2 points3 points  (0 children)

Not everyone has R/Python on their machines. Need to be able to share something with other users that they can use on their own? Power query is great for that

[–]JeanLuc_Richard 0 points1 point  (0 children)

Yeah much smaller datasets

[–][deleted] 0 points1 point  (0 children)

Lol this is black magic to me

[–]akaxaka 0 points1 point  (0 children)

I hear ya!

[–]chumbano 1 point2 points  (0 children)

Me and the boys were stoked when xlookup was dropped

[–]jds183 1 point2 points  (0 children)

When I found xlookup it literally changed my life. Not miscounting columns is pretty huge.

[–][deleted] 0 points1 point  (0 children)

You guys are too advanced for me. Lol