Split Column Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/split-column/ Bestselling Excel and Power BI Courses Mon, 24 Apr 2023 15:34:40 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Split Column Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/split-column/ 32 32 How to Transpose Mutliple Header Rows to Columns in Excel – Advanced Unpivot Techniques https://www.xelplus.com/excel-advanced-unpivot-power-query/ Thu, 16 Jul 2020 09:00:00 +0000 https://www.xelplus.com/?p=10862 You can easily use Excel Power Query to transpose a data-set with multiple row headers from multiple columns to rows. Find out how in this quick tutorial.

The post How to Transpose Mutliple Header Rows to Columns in Excel – Advanced Unpivot Techniques appeared first on Xelplus - Leila Gharani.

]]> How to Transform Text with Power Query – Upper Case, Split Text or Format Text Easily https://www.xelplus.com/excel-text-transformation-power-query/ Thu, 11 Jun 2020 09:00:00 +0000 https://www.xelplus.com/?p=11298 Discover the Easiest way to transform text in Excel. Separate words, split cells by delimiter, extract text after space, extract numbers from text and a lot more. Excel Power Query has powerful text transformation options.

The post How to Transform Text with Power Query – Upper Case, Split Text or Format Text Easily appeared first on Xelplus - Leila Gharani.

]]>