Custom Column Archives - Xelplus - Leila Gharani

How to Repeat Table Values x Times Using Power Query

Leila Gharani — Thu, 07 Oct 2021 08:00:00 +0000

With this trick you can easily combine and repeat blocks of values together in Excel. You don't need copy pasting or complicated formulas. Just a tiny bit of Power Query. This keeps your solution dynamic too.

The post How to Repeat Table Values x Times Using Power Query appeared first on Xelplus - Leila Gharani.

Excel Convert Multiple Rows to Columns (Transpose but with Multiple Values)

Leila Gharani — Thu, 29 Jul 2021 08:00:00 +0000

Pivoting columns in Excel is a common task when cleaning and organizing data. Sometimes you have a complex scenario where you have multiple values when switching columns. You'll have to combine these multiple values into one cell. I'll show you 3 methods to get this done.

The post Excel Convert Multiple Rows to Columns (Transpose but with Multiple Values) appeared first on Xelplus - Leila Gharani.

How to Create a Pivot Table from Multiple Sheets in Excel

Leila Gharani — Thu, 01 Jul 2021 08:00:00 +0000

Easily create ONE Pivot Table in Excel from data in multiple sheets. Sometimes you need to "merge" the data and sometimes you have to "append" data from multiple sheets for your Pivot Table. Don't use formulas! Instead use this method.

The post How to Create a Pivot Table from Multiple Sheets in Excel appeared first on Xelplus - Leila Gharani.