Use Power Query to transform incorrect data format and layout to an acceptable layout to be used for data analysis with Pivot Tables.
Sometimes you find data in rows and columns and cannot use them in a pivot table. We need data in columns to be used in pivot tables. This video will show you how to transform this data in columns.

свернуть