Did you know duckdb.org's UNPIVOT feature?
You rarely need them but from time to time PIVOT and UNPIVOT really help to keep your SQL easy to read:
PIVOT turns one row into multiple columns.
UNPIVOT turns columns into multiple rows.
1/2
You rarely need them but from time to time PIVOT and UNPIVOT really help to keep your SQL easy to read:
PIVOT turns one row into multiple columns.
UNPIVOT turns columns into multiple rows.
1/2
May 7, 2026 at 8:45 AM
Did you know duckdb.org's UNPIVOT feature?
You rarely need them but from time to time PIVOT and UNPIVOT really help to keep your SQL easy to read:
PIVOT turns one row into multiple columns.
UNPIVOT turns columns into multiple rows.
1/2
You rarely need them but from time to time PIVOT and UNPIVOT really help to keep your SQL easy to read:
PIVOT turns one row into multiple columns.
UNPIVOT turns columns into multiple rows.
1/2
If you’re into data then I highly ( and unashamedly ) recommend our podcast - UNPIVOT
#Excel #PowerBI
bio.link/unpivot
#Excel #PowerBI
bio.link/unpivot
February 1, 2026 at 4:43 AM
If you’re into data then I highly ( and unashamedly ) recommend our podcast - UNPIVOT
#Excel #PowerBI
bio.link/unpivot
#Excel #PowerBI
bio.link/unpivot
@exceloffthegrid.bsky.social coined that one. I’ve literally just bought the t-shirt 🤣 div0.myspreadshop.com.au/prompt+bingo...
Mens Premium T-Shirt | Unpivot
Prompt Bingo Surf? ⭐ unpivot, Surf ❗ bingo
div0.myspreadshop.com.au
March 7, 2026 at 11:21 AM
@exceloffthegrid.bsky.social coined that one. I’ve literally just bought the t-shirt 🤣 div0.myspreadshop.com.au/prompt+bingo...
In this video blog, I show how to unpivot a complex table made of nested subtables with #PowerQuery (for use in #Excel or #PowerBI). Combining 2 PQ recipe patterns (Unpivot Subcategorized Tables and Pivot Stacked Data), it shows just how robust a PQ solution can be! www.youtube.com/watch?v=IIFr...
Practical Power Query: Unpivot Nested Tables
YouTube video by Skillwave Training
www.youtube.com
March 17, 2025 at 5:46 PM
In this video blog, I show how to unpivot a complex table made of nested subtables with #PowerQuery (for use in #Excel or #PowerBI). Combining 2 PQ recipe patterns (Unpivot Subcategorized Tables and Pivot Stacked Data), it shows just how robust a PQ solution can be! www.youtube.com/watch?v=IIFr...
New Unpivot podcast episode!
March 9, 2026 at 5:45 PM
New Unpivot podcast episode!
August 9, 2024 at 2:03 PM
December 6, 2025 at 11:40 PM
Convert rows to columns in Oracle #SQL with:
PIVOT ( agg_fn FOR col IN ( 'val1', 'val2', ... ) )
And columns back to rows using
UNPIVOT ( val FOR col IN ( col1, col2, ... ) )
Killian Lynch dives into the details
PIVOT ( agg_fn FOR col IN ( 'val1', 'val2', ... ) )
And columns back to rows using
UNPIVOT ( val FOR col IN ( col1, col2, ... ) )
Killian Lynch dives into the details
PIVOT and UNPIVOT in the Oracle Database
This week's throwback feature of the week is a simple and relatively well known SQL Operator. It's the ability to pivot and unpivot SQL columns inside a table. Pivoting and Unpivoting inside a table…
buff.ly
May 7, 2025 at 11:03 AM
Convert rows to columns in Oracle #SQL with:
PIVOT ( agg_fn FOR col IN ( 'val1', 'val2', ... ) )
And columns back to rows using
UNPIVOT ( val FOR col IN ( col1, col2, ... ) )
Killian Lynch dives into the details
PIVOT ( agg_fn FOR col IN ( 'val1', 'val2', ... ) )
And columns back to rows using
UNPIVOT ( val FOR col IN ( col1, col2, ... ) )
Killian Lynch dives into the details
An UNPIVOT I had tested on 84M rows was 5.5s on 1.1.3, 4.5s on 1.2, and after this PR, 300ms. That's 15x faster without any query changes! Incredible work. I'm much more likely now to use UNPIVOT than the workarounds in the linked gist.
github.com/duckdb/duckd...
gist.github.com/xevix/bbdd26...
github.com/duckdb/duckd...
gist.github.com/xevix/bbdd26...
Avoid unnecessarily projecting the input columns of the UNPIVOT operator in the UNNEST by Mytherin · Pull Request #16221 · duckdb/duckdb
Fixes #13552
This greatly improves performance when unpivoting on many columns. Previously these columns would be projected out and then immediately discarded - leading to a lot of wasted time.
Bel...
github.com
February 13, 2025 at 11:17 PM
An UNPIVOT I had tested on 84M rows was 5.5s on 1.1.3, 4.5s on 1.2, and after this PR, 300ms. That's 15x faster without any query changes! Incredible work. I'm much more likely now to use UNPIVOT than the workarounds in the linked gist.
github.com/duckdb/duckd...
gist.github.com/xevix/bbdd26...
github.com/duckdb/duckd...
gist.github.com/xevix/bbdd26...
Join us for surprise guest ( well you can see who it is 😆 )
Links to podcast: bio.link/unpivot
youtu.be/NrD7q_SpfHc?...
Links to podcast: bio.link/unpivot
youtu.be/NrD7q_SpfHc?...
Bill Jelen a.k.a. Mr Excel
YouTube video by Unpivot
youtu.be
July 5, 2025 at 4:24 AM
Join us for surprise guest ( well you can see who it is 😆 )
Links to podcast: bio.link/unpivot
youtu.be/NrD7q_SpfHc?...
Links to podcast: bio.link/unpivot
youtu.be/NrD7q_SpfHc?...
Thanks to Chandeep Chhabra for joining as on Unpivot.
🟢 Chandeep gets us chatting on everything from best ways to engage course attendees to handstand practice.
Also on Apple, Spotify and Podbean
#Excel #PowerBI
youtu.be/sTpub9cUxrU?...
🟢 Chandeep gets us chatting on everything from best ways to engage course attendees to handstand practice.
Also on Apple, Spotify and Podbean
#Excel #PowerBI
youtu.be/sTpub9cUxrU?...
With Chandeep Chhabra - Wow Factor Demos - Adapting when moving from Excel to Power BI
YouTube video by Unpivot
youtu.be
December 7, 2024 at 1:50 PM
Thanks to Chandeep Chhabra for joining as on Unpivot.
🟢 Chandeep gets us chatting on everything from best ways to engage course attendees to handstand practice.
Also on Apple, Spotify and Podbean
#Excel #PowerBI
youtu.be/sTpub9cUxrU?...
🟢 Chandeep gets us chatting on everything from best ways to engage course attendees to handstand practice.
Also on Apple, Spotify and Podbean
#Excel #PowerBI
youtu.be/sTpub9cUxrU?...
The latest episode of Unpivot. Join us as we talk a lot of nonsense with a sprinkling of useful info
#PowerBI #Excel
#PowerBI #Excel
Question of the Week:
How to quote for your time and effort?
Other topics....
🟢 How do you get to 100K subscribers
🟢 Are Lambdas a black box?
🟢 Sue is not happy with Mark
🟢 Mark drops shade on Wyn's REGEX idea
Episodes can be found via unpivot.bio.link
How to quote for your time and effort?
Other topics....
🟢 How do you get to 100K subscribers
🟢 Are Lambdas a black box?
🟢 Sue is not happy with Mark
🟢 Mark drops shade on Wyn's REGEX idea
Episodes can be found via unpivot.bio.link
March 29, 2025 at 2:37 PM
I had an absolute BLAST being on the latest episode of the Unpivot podcast! 😁 Give it a listen if you have then chance.
Check out our latest episode with the legend that is Ken Puls
Our thumbnail has been updated in honour of Ken's love of ChatGPT!
YouTube, Podcasts and hosts: bio.link/unpivot
We also discuss what motivates, why we shouldn't worry about keeping up
#Excel #PowerBsi
Our thumbnail has been updated in honour of Ken's love of ChatGPT!
YouTube, Podcasts and hosts: bio.link/unpivot
We also discuss what motivates, why we shouldn't worry about keeping up
#Excel #PowerBsi
June 9, 2025 at 5:29 PM
I had an absolute BLAST being on the latest episode of the Unpivot podcast! 😁 Give it a listen if you have then chance.
This is a doozy! Watch 2 minutes and simply use it or watch the full video to understand how it works!
UNPIVOT in #Excel Without Power Query?
youtu.be/Ie6OiuIBpjk
UNPIVOT in #Excel Without Power Query?
youtu.be/Ie6OiuIBpjk
UNPIVOT in Excel Without Power Query? YES, With This Function!
YouTube video by Access Analytic
youtu.be
May 14, 2025 at 9:56 AM
This is a doozy! Watch 2 minutes and simply use it or watch the full video to understand how it works!
UNPIVOT in #Excel Without Power Query?
youtu.be/Ie6OiuIBpjk
UNPIVOT in #Excel Without Power Query?
youtu.be/Ie6OiuIBpjk
A slight divergence between title and image - but if you can’t have a laugh when AI is going to kill us all and Microsoft are ripping Dataflows from our cold dead hands, when can you laugh?
#PowerBI #Excel #Unpivot
youtu.be/pHmHGGx4x2I?...
#PowerBI #Excel #Unpivot
youtu.be/pHmHGGx4x2I?...
50th Episode.. We're doomed!
YouTube video by Unpivot
youtu.be
April 18, 2026 at 6:07 AM
A slight divergence between title and image - but if you can’t have a laugh when AI is going to kill us all and Microsoft are ripping Dataflows from our cold dead hands, when can you laugh?
#PowerBI #Excel #Unpivot
youtu.be/pHmHGGx4x2I?...
#PowerBI #Excel #Unpivot
youtu.be/pHmHGGx4x2I?...
Excel Summit, ABBA and Presentation Tips
QotW: What are you tips for delivering good presentations?
🟢Mark explains why he doesn't like Chris Webb
🟢Giles is sick but soldiers on
🟢Sue did DP700 exam and presentation
🟢Wyn needs to work on Irish names
Links: bio.link/unpivot
#Excel #PowerBI
QotW: What are you tips for delivering good presentations?
🟢Mark explains why he doesn't like Chris Webb
🟢Giles is sick but soldiers on
🟢Sue did DP700 exam and presentation
🟢Wyn needs to work on Irish names
Links: bio.link/unpivot
#Excel #PowerBI
February 15, 2025 at 2:32 AM
Excel Summit, ABBA and Presentation Tips
QotW: What are you tips for delivering good presentations?
🟢Mark explains why he doesn't like Chris Webb
🟢Giles is sick but soldiers on
🟢Sue did DP700 exam and presentation
🟢Wyn needs to work on Irish names
Links: bio.link/unpivot
#Excel #PowerBI
QotW: What are you tips for delivering good presentations?
🟢Mark explains why he doesn't like Chris Webb
🟢Giles is sick but soldiers on
🟢Sue did DP700 exam and presentation
🟢Wyn needs to work on Irish names
Links: bio.link/unpivot
#Excel #PowerBI
Session Spotlight: Jeff Foushee talks about
SQL Server’s lesser-known PIVOT and UNPIVOT operators.
🎟 Register + Brent's precon : www.eventbrite.com/e/sql-saturd...
SQL Server’s lesser-known PIVOT and UNPIVOT operators.
🎟 Register + Brent's precon : www.eventbrite.com/e/sql-saturd...
August 15, 2025 at 4:25 PM
Session Spotlight: Jeff Foushee talks about
SQL Server’s lesser-known PIVOT and UNPIVOT operators.
🎟 Register + Brent's precon : www.eventbrite.com/e/sql-saturd...
SQL Server’s lesser-known PIVOT and UNPIVOT operators.
🎟 Register + Brent's precon : www.eventbrite.com/e/sql-saturd...
Check out our latest episode with the legend that is Ken Puls
Our thumbnail has been updated in honour of Ken's love of ChatGPT!
YouTube, Podcasts and hosts: bio.link/unpivot
We also discuss what motivates, why we shouldn't worry about keeping up
#Excel #PowerBsi
Our thumbnail has been updated in honour of Ken's love of ChatGPT!
YouTube, Podcasts and hosts: bio.link/unpivot
We also discuss what motivates, why we shouldn't worry about keeping up
#Excel #PowerBsi
June 7, 2025 at 1:50 PM
Check out our latest episode with the legend that is Ken Puls
Our thumbnail has been updated in honour of Ken's love of ChatGPT!
YouTube, Podcasts and hosts: bio.link/unpivot
We also discuss what motivates, why we shouldn't worry about keeping up
#Excel #PowerBsi
Our thumbnail has been updated in honour of Ken's love of ChatGPT!
YouTube, Podcasts and hosts: bio.link/unpivot
We also discuss what motivates, why we shouldn't worry about keeping up
#Excel #PowerBsi
Check out the latest 2 episodes:
Should #PowerBI be part of #MicrosoftFabric
When does an organisation outgrow #Excel?
youtube.com/playlist?lis...
🍎 podcasts.apple.com/au/podcast/u...
Spotify: open.spotify.com/show/4EYX2SF...
Should #PowerBI be part of #MicrosoftFabric
When does an organisation outgrow #Excel?
youtube.com/playlist?lis...
🍎 podcasts.apple.com/au/podcast/u...
Spotify: open.spotify.com/show/4EYX2SF...
The Unpivot Show Podcast - YouTube
A friendly light-hearted chat about the world of Excel and Power BI
youtube.com
January 20, 2025 at 10:28 AM
Check out the latest 2 episodes:
Should #PowerBI be part of #MicrosoftFabric
When does an organisation outgrow #Excel?
youtube.com/playlist?lis...
🍎 podcasts.apple.com/au/podcast/u...
Spotify: open.spotify.com/show/4EYX2SF...
Should #PowerBI be part of #MicrosoftFabric
When does an organisation outgrow #Excel?
youtube.com/playlist?lis...
🍎 podcasts.apple.com/au/podcast/u...
Spotify: open.spotify.com/show/4EYX2SF...