Data Transformation to Create Comma Separated List Automatically
Data transformation is an important aspect of data analysis and is often used to manipulate data in a way that suits our needs. One such manipulation is to Create Comma
Tag: Sort
Searchable and Dependent Drop-down list in Microsoft Excel
In this article, we have created a Searchable and Dependent Drop-down list in Microsoft Excel. We have used Dynamic Array function of office 365 to create the drop-down list. We
5 Quick Productive Tips in Microsoft Excel
In this article, you will learn the 5 Productive Tips in Microsoft Excel to improve the productivity in Microsoft Excel. 5 Quick Productive Tips in Microsoft Excel Tip #1: Auto
Sort Data by Custom List in Excel (Months, Sizes and More)
When you sort data by custom list in Excel, you choose the order yourself instead of accepting A to Z. That matters for month names, T-shirt sizes, priority levels and