Remove Line Breaks using Power Query

In the previous video and blog post, we considered how to use FILTERXML combined with arrays of functions to remove line breaks. In this tutorial, we shall learn how to perform the same operation using the Power Query. Let’s get started. Video Do take time to watch the tutorial video and subscribe to the YouTube Channel Sample Data In the […]

Continue reading

Shuffle Data using Dynamic Arrays

Introduction Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to use Sortby and Randarray Dynamic Arrays to shuffle dataset in Microsoft Excel. Let’s get started. Video Do watch the video below. Share, like, comment and subscribe Sample Data In the caption below, we have the sample data showing records for Order Date all through […]

Continue reading