Unpivot

QOTW: What are the first things you do on a new project? Plus, the usual banter: 🤖 Copilot, Fable and real-world experience 🏃🏻‍♀️‍➡️Dartmoor Run 📺TV Recommendation - Man on Fire TV Series ( Netflix ) 📗Book Recommendation https://markjdawson.com/books/john-milton-series/ 😴🥱 Value-gate, the pod's worst discussion since Wire-gate ( sorted numbers totalling differently ) 🐏Chopped Mutton? https://tableandspoon.com/why-do-people-use-the-phrase-chopped-liver/ 🗣️ Welsh / Australian / South African ? 📷Camera Fail Unpivot Show Links PageHosts Wyn Hopkins, Mark Proctor, Sue Bayes and Giles Male.

Question of the Week: 2026 Plans and coping with back to work blues.🧢👕Unpivot Merch🌏Global Excel Summit: UNPIVOT for 10% off Warning: May Contain Traces of Technical Content 🍫🪓Chocolate Chisels❄️Snow🚃Stockholm🛷 Stair Sledging🦒Australian Christmas🛞Wagon Wheels🎯Long Distance Darts😰January Blues🤔2025 Review Unpivot Show Links PageHosts Wyn Hopkins, Mark Proctor, Sue Bayes and Giles Male.

Question of the Day: When you open a file what are the Red Flags 🚩 that indicates it wasn't created by an expert?Special Guest Cristian Angyal https://www.linkedin.com/in/cristian-angyal/🔄️ Will Online Schedule refresh ever come to Excel?🔏 Password Weakness in Excel👉🏻 SharePoint List Refresh speed up 🐍 Python in Google https://colab.google/ 🚩Any File not created by Mark 🧢👕Unpivot Merch🌏Global Excel Summit: UNPIVOT for 10% off

Trolls, Features and Common Data problems. In this chaotic episode of Unpivot, the gang kicks things off with Halloween antics and quickly spirals into the wild world of Excel, Power BI, and internet comment drama. From TikTok trolls who think Power Pivot lives in Access (spoiler: it doesn’t) to debates about whether picking pumpkins is just muddy shopping, it’s a rollercoaster of laughs and learning. They also dive into juicy new features like visual calcs, agent mode, and formula-by-example, and share their favourite ways to handle messy data, missing dates, and the eternal mystery of “what does sales actually mean?” Question of the Week: What are Common Data Problems you come across 🎃 What does "Pick your own" actually mean? 😡 Haters gonna Hate 👩‍💻 Lots of New Features in Excel and Power BI 📊 Visual calcs 🤔 Is Excel a database? Unpivot Show Links PageHosts Wyn Hopkins, Mark Proctor, Sue Bayes and Giles Male.

Question of the Week: What shall we ask Deb and Leila?🚩Red Flags 🦹Serial Killer Tips? 🤖 Excel Agent Mode ➡️ Swipe Right? ❓Excel Autocomplete 🏃‍♀️‍➡️ Is Speed Good? 🔢 Prompt Bingo 🍓Strawberry Laces 🩳Short Shorts? 🎛️ Video Editor TipsThanks to our special GuestsDeb Ashby Cellmates - YouTubeLeila Gharani https://www.youtube.com/@LeilaGharani Links to regular hosts and other content Unpivot Show Links Page

Question of the Week: What's your favourite hardware? ⌚Tardy Giles 🎤 Rap Review ❎ Sue's XLOOKUP admission ⌨️Fn Backspace 🕜Sue's mysterious object 🤬Cross(ed) Wires - the most boring topic so far goes off! ⏲️ They call him Mark "High-Tech" Proctor 🦶🏻Foot Fans? ✈️Cabeau https://cabeau.com/products/evolution-s3-neck-pillowLinks to hosts and other content Unpivot Show Links Page

Special guest Ken Puls returns to the pod this week. Question of the week: What technologies are you currently ignoring and why? Other topics: 😴 Falling asleep during presentations🐻 Out running a bear🙊 Don’t say the C word 💬 Arguing with AI Links to hosts and other content Unpivot Show Links PageHosts Wyn Hopkins, Mark Proctor, Sue Bayes and Giles Male. 🐒🔨🪛Ken Puls: https://excelguru.ca/

Sue's back! Question of the Week: How do you set things up for when you're away Mark's offer: https://exceloffthegrid.com/modern-excel-formulas/ 🔄️Pivot Refresh ☠️ Giles's new Tattoo ↔️ Excel compatibility versions 🐻 Running in the woods with Bears 🧑🏻‍✈️ Power BI Copilot Links to hosts and other content Unpivot Show Links PageHosts Wyn Hopkins, Mark Proctor, Sue Bayes and Giles Male.