Have you ever set up a nice query to UnPivot other columns, only to find that the query data types change when you add new columns? This post will cover why values become text after unpivoting other columns. Background We’ve
It’s a busy month here at Excelguru. Instead of a technical post we wanted to catch everyone up on our October news and events! Live Course: Master Your Excel Data Ken is teaching a LIVE, hands on course in Victoria, BC
We're back with post two of Miguel's week. This time, he is going to take his previous solution and show us how versatile Power Query can be, leveraging code he's already written and Making Transformations Re-Usable. Have at it, Miguel! Making Transformations Re-Usable In
This week we've got a guest post from Miguel Escobar, who is going to tell us why transforming data with Power Query is his first preference versus other tools and methods. In fact, this is part 1 of 2, and
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
