#1
|
|||
|
|||
Transform Repeating Rows into Column Headings
When using SQL Server, I had a way to transform (Pivot) the unique values in a column and make them column headings. I am trying to figure out how to do this using the Excel Transform feature that is new to Excel 2019. In the attached file, I want to transform the three unique values in the Course column and make them three separate column headings. The corresponding dates would then move into one row for each person making the report more compact.
Any help on how to accomplish this would be much appreciated. Thanks |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Repeating Header Rows disappeared! | macgregorga | Word Tables | 1 | 01-09-2020 09:51 PM |
repeating two rows (including merge) as table heading | eNGiNe | Word | 4 | 10-18-2017 10:57 PM |
Repeating Section (Need Multiple values from different excel rows into one document) | NotSaying | Mail Merge | 3 | 09-27-2016 02:08 PM |
Repeating or freezing header rows | DLeighC | OneNote | 1 | 09-05-2015 06:49 AM |
Repeating table rows in template? | TheWedgie | Word | 0 | 09-11-2010 09:35 PM |