https:\/\/excelisfun.net\/files\/EMT1854-1856.xlsx<\/a>
\nLearn how to group transactions with no key or invoice number using Power Query and the Table.Group fourth and fifth arguments: groupKind and comparer function. Group By when there is no key column and there are duplicates and empty cells. How to group transactions with no transaction number and repeating dates and empty cells.
\nTopics:
\n1. (00:00) Introduction
\n2. (00:28) Group By Date Column with two aggregate calculations: join descriptions and sum amount.
\n3. (01:00) Text.Combine with Column Lookup to join descriptions
\n4. (02:10) Table.Group fourth argument: groupKind using GroupKing.Local or zero, 0
\n5. (02:56) Table.Group fifth argument: comparer function
\n6. (05:29) Summary
\n7. (05:43) Closing, Video Links<\/p>\n#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp
\nExamples of Table.Group fourth argument, groupKind argument
\nExamples of Table.Group fifth argument, Comparer argument
\nTable.Group fourth argument
\nTable.Group fifth argument
\nTable.Group groupKind argument
\nTable.Group comparer argument<\/p>\n","protected":false},"excerpt":{"rendered":"
Download Excel File: https:\/\/excelisfun.net\/files\/EMT1854-1856.xlsx Learn how to group transactions with no key or invoice number using Power Query and the Table.Group fourth and fifth arguments: groupKind and comparer function. Group By when there is no key column and there are duplicates and empty cells. How to group transactions with no transaction number and repeating dates […]<\/p>\n","protected":false},"author":3,"featured_media":6654,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[101,21],"tags":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/bonbonsguide.com\/wp\/wp-content\/uploads\/2024\/03\/ayaV_o7lVGo.jpg?fit=1280%2C720&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7QB1z-1Jj","_links":{"self":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/6653"}],"collection":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/comments?post=6653"}],"version-history":[{"count":0,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/6653\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media\/6654"}],"wp:attachment":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media?parent=6653"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/categories?post=6653"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/tags?post=6653"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}