fbpx
Skip to content
DataChant
Menu
  • Book
    • Book Q&A
    • Excerpts & Extras
  • About
    • About Gil
    • Subscriber’s Corner
    • Archived Gallery
  • Power BI Apps on AppSource
    • Mailchimp
    • ActiveCampaign
    • ActiveCampaign PBIX Instructions
    • Dataflows Snapshot Analysis
    • Power Apps Dataflows Snapshot Analysis
    • Excel Compare
    • Twitter Dashboard
  • Book
    • Book Q&A
    • Excerpts & Extras
  • About
    • About Gil
    • Subscriber’s Corner
    • Archived Gallery
  • Power BI Apps on AppSource
    • Mailchimp
    • ActiveCampaign
    • ActiveCampaign PBIX Instructions
    • Dataflows Snapshot Analysis
    • Power Apps Dataflows Snapshot Analysis
    • Excel Compare
    • Twitter Dashboard

Tag: Unpivot

mon Data Patterns You've Never Dared To Transform Popular

Common Data Patterns You’ve Never Dared to Transform – Global #PowerBI Webcast

Gil RavivJanuary 21, 20173
If you have missed my webcast on Global Power BI User Group, you can now watch the recording, and download the Power BI files (details...
Popular

Split and Unpivot Comma-Separated Values

Gil RavivJanuary 13, 20167
By now, if you read my previous posts in the series The Definitive Guide to Unpivot in Excel (all posts here), you will feel confident with the following...
Popular

Unpivot ANY nested table and load to Power BI Desktop

Gil RavivJanuary 3, 20166
Earlier today I shared with you a function query here that unpivots ANY nested table into Excel and transforms summarized tables into a PivotTable. This post...
Unpivot - The definitive guide

Transform ANY nested table to Pivot Table with function query

Gil RavivJanuary 3, 20163
Get ready to be amazed :) This is the fourth post in the series The Definitive Guide to Unpivot with Power Query in Excel. In this series we walk you...
Unpivot - The definitive guide

Transform a nested table to PivotTable

Gil RavivJanuary 3, 20160
This is the third post in the series The Definitive Guide to Unpivot with Power Query in Excel. In this series we walk you through one of the coolest data...
Unpivot - The definitive guide

Back to School – Transform class schedule to PivotTable

Gil RavivJanuary 3, 20162
Back to school with Excel & Power Query This is the second post in the series The Definitive Guide to Unpivot with Power Query in Excel. For today's post...
Unpivot - The definitive guide

Transform already-pivoted tables to PivotTable (The Definitive Guide to Unpivot with Power Query in Excel)

Gil RavivJanuary 3, 20160
This post is the first in a series of posts that will walk you through one of the coolest data transformation features in Excel. If you are not familiar with...
Unpivot Any table in Excel 2016

Unpivot Any table in Excel 2016

Gil RavivDecember 15, 20150
My Unpivot series just got published on Office Blogs here. Enjoy reading...

Write a Review

Install our Power BI Apps on AppSource

Tags

#MSDataSummit AppSource Bad Practices Bonus Exercise Book COVID-19 Custom Visuals Data Quality Automation DAX Excel Excel 2016 Facebook Facebook bug Facebook Insights Facebook Reactions Get & Transform Jedi List.Accumulate List.Generate Logs MailChimp Microsoft Cognitive Services Multiline records MVP Pitfalls PivotTable Power BI Power BI Governance Power Pivot Power Query Power Query Book Robust Queries Sentiment Analysis Star Wars Subscribers Tableau vs Power BI Template Apps Text Analytics Twitter Analytics Unpivot Update US Election Candidates US Presidential Candidates Webinar Web Scraping

Blog Stats

  • 1,548,467 Views
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Privacy Policy
  • Home
  • Shop
  • Book
  • About

Copyright 2021 DataChant Consulting LLC All Rights Reserved

 

Loading Comments...