![]() ![]() Click on the Transform Menu - Pivot Column.Select the column that has the names of the new columns.Convert the fields to the appropriate type, in this case, time. Confirm the selection and if it has headers.Select the data, click on Data Menu - From Table/Range (in Excel 2016 or higher) or in the Power Query Menu - From Table/Range (Excel Import the desired data to a blank Excel sheet.Mac users: Power Query is not available for this platform yet.Windows + Excel 2010-2013 with the Microsoft Power Query tool installed.It is also much simpler than typing codes and don't require any 3rd party add-on. ![]() This solution is far better than Formulas or VBA Macros because the categories/columns can be auto-updated according to the data source changes. This solution does not require macros or long search/replace functions, just the Microsoft Power Query tool that comes with Excel 2016 or can be installed for free as an add-on in previous versions. Create a Pivot table that displays text data or number values that are not summarized (count, sum, etc.). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |