Skip to content

XL n CAD

Excel isn’t just a tool – it’s a way of Life!

  • Excel
    • Excel Functions
    • Excel Formulas
    • Excel Table
    • Macros
    • Formula Errors
    • Power Query
    • Downloads
  • Blog
    • Excel
    • Power Query
  • Shortcuts
    • 200+ Excel Shortcuts
    • Shift Key Shortcuts
    • Functions Key Shortcuts
    • Ctrl Key Shortcuts
    • Videos
  • AutoCAD
    • Macros (VBA for AutoCAD)
    • Scripting in AutoCAD
    • AutoCAD Command Alias
    • Complete List of AutoCAD Commands
    • Tips & Tricks
  • Excel Malayalam
  • Power Query
    • Power Query Editor
    • Blog Posts on Power Query
    • Videos
  • Resources

Tag: Fill Blanks cells Excel

Ajay Anand

Fill Up and Fill Down using Power Query in Excel

Fill Up and Fill Down using Power Query in Excel

I this blog post, I will explain the Fill Up and Fill Down Transformation steps in Power Query of Excel with a simple example. Following is the collection report of Infinity Saga which comprises of 23 Marvel movies that were released in 3 Phases. I want to create two reports from this data. 1. Phase-wise…

Read More

Recent Posts

  • Python Program to Edit Excel Files
  • Python Program to Read Excel Files
  • VLOOKUP from Two or more Tables

Archives

  • March 2023
  • May 2022
  • April 2022
  • March 2022
  • November 2021
  • May 2021
  • April 2021
  • February 2021
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • February 2020
  • January 2020
  • December 2019
  • July 2019
  • June 2019
  • April 2019

Fly to

  • Excel
    • Excel Functions
    • Excel Formulas
    • Excel Table
    • Macros
    • Formula Errors
    • Power Query
    • Downloads
  • Blog
    • Excel
    • Power Query
  • Shortcuts
    • 200+ Excel Shortcuts
    • Shift Key Shortcuts
    • Functions Key Shortcuts
    • Ctrl Key Shortcuts
    • Videos
  • AutoCAD
    • Macros (VBA for AutoCAD)
    • Scripting in AutoCAD
    • AutoCAD Command Alias
    • Complete List of AutoCAD Commands
    • Tips & Tricks
  • Excel Malayalam
  • Power Query
    • Power Query Editor
    • Blog Posts on Power Query
    • Videos
  • Resources

Top 25 MS Word Tips & Tricks

https://youtu.be/l25Evu4ohKg

Course on Scripting in AutoCAD

Recent Posts

  • Python Program to Edit Excel Files
  • Python Program to Read Excel Files
  • VLOOKUP from Two or more Tables
  • TEXTSPLIT and 13 New Functions in Excel
  • How to find the Most Repeated Text or Number in Excel

Categories

  • Advanced Excel (3)
  • AutoCAD (3)
  • Conditional Formatting (2)
  • Data Validation (2)
  • Excel Charts (3)
  • Excel Errors (1)
  • Excel Formula (28)
  • Excel Functions (14)
  • Excel Macro (4)
  • Excel Shortcuts (2)
  • Excel Table (2)
  • Excel Tips and Tricks (41)
  • Excel Tutorial (3)
  • Google Maps (1)
  • GoogleSheets (1)
  • MS Excel (84)
  • MS Word (4)
  • Pivot Table (4)
  • Power Query (30)
  • PowerPoint (1)
  • Python (2)
  • Uncategorized (4)

© 2025 XL n CAD | WordPress Theme: Attesa by AttesaWP.com

Categories

  • Advanced Excel
  • AutoCAD
  • Conditional Formatting
  • Data Validation
  • Excel Charts
  • Excel Errors
  • Excel Formula
  • Excel Functions
  • Excel Macro
  • Excel Shortcuts
  • Excel Table
  • Excel Tips and Tricks
  • Excel Tutorial
  • Google Maps
  • GoogleSheets
  • MS Excel
  • MS Word
  • Pivot Table
  • Power Query
  • PowerPoint
  • Python
  • Uncategorized