About this tutorial:
Video duration: 00:17:08
In this video you’ll learn how to switch data in columns to rows. Pivoting columns in Excel is a common problem when cleaning and organizing data. In this case however, we have a more complex scenario where we have multiple values when pivoting data. We’ll have to combine these multiple values into one cell. I’ll show you 3 methods to get this done. We’ll use Dynamic array Formulas, Power Query (Pivot columns with multiple records) and finally Power Pivot and DAX (CONCATENEX together with HASONEFILTER).
00:00 Transform Data in Tables from Columns to Rows
01:10 How to Use…