3 Ways to Switch Data in Columns to Rows in Excel (Multiple Values)




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).

Timestamps
00:00 Transform Data in Tables from Columns to Rows
01:10 How to Use…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads