Unpivot Columns in Excel - Get & Transform Data - Part 1 of 3 - by Chris Menard скачать в хорошем качестве

Unpivot Columns in Excel - Get & Transform Data - Part 1 of 3 - by Chris Menard

In Excel, use the Get & Transform to unpivot columns and transform your data. If your data is not set up correctly, you can't sort, filter, subtotal, or create pivottables. To transform your data, use the Power Query Editor. It transforms your columns into rows. It is located in Excel 2016 with the Get & Transform Data group on the Data tab. It is also available in Excel 2019, Excel 2013, and Excel 2010. The Microsoft support articles are below. Example: In row 1, starting in cell B1, are either employee's names, months, countries, or states. In A1 is a category that is correctly set up. Let's assume it is products in column A. The data starting in B1 needs to be labeled, and then run down column B, not across. Column C would have the values. ** Microsoft Support Articles ** Unpivot columns https://support.office.com/en-us/arti... Getting started with Power Query https://support.office.com/en-us/arti... Chris Menard''s Website: https://chrismenardtraining.com And make sure you subscribe to my channel! - EQUIPMENT USED -------------------------------- ○ My camera – https://amzn.to/3vdgF5E ○ Microphone - https://amzn.to/3gphDXh ○ Camera tripod – https://amzn.to/3veN6Rg ○ Studio lights - https://amzn.to/3vaxyy5 ○ Dual monitor mount stand - https://amzn.to/3vbZSjJ ○ Web camera – https://amzn.to/2Tg75Sn ○ Shock mount - https://amzn.to/3g96FGj ○ Boom Arm - https://amzn.to/3g8cNi6 - SOFTWARE USED -------------------------------- ○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia ○ Screenshots – Snagit – https://chrismenardtraining.com/snagit ○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!