Data Consolidation Archives - PK: An Excel Expert

Quick Merge Multiple Columns using TOCOL Function

January 11, 2024June 18, 2024 PKComments Off

Are you struggling with organizing vast amounts of data across multiple columns in Excel? Look no further! Our latest YouTube video, "Quick Merge Multiple Columns using TOCOL Function!" offers a

Charts and Visualization

Dynamic Pivot Table with Multiple Tables using Power Query

January 31, 2021August 23, 2024 PKComments Off

In this article, we have created a dynamic Pivot Table with Multiple Tables using Power Query. We have taken 4 different yearly Sales Table as given in below image- Dynamic Pivot

Power Pivot Dashboard

Fully Automated Excel dashboard with multiple source files

April 12, 2020February 18, 2025 PKComments Off

In this article, we have create a full automatic excel dashboard with multiple excel source files. Each source file can have multiple worksheets. For data consolidation we have used Power

VBA

Data Consolidation: Allow User to select files on Runtime

April 8, 2019March 11, 2025 PKComments Off

In this article, we will explain to you the Data Consolidation from multiple Excel files using Application.GetOpenFileName in VBA. You can easily allow the user to select multiple excel files