![]() |
#2
|
||||
|
||||
![]()
With Power Query/Get and Transform Data
Code:
let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date Enrolled", type date}}), #"Pivoted Column" = Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[Course]), "Course", "Date Enrolled") in #"Pivoted Column"
__________________
Alan עַם יִשְׂרָאֵל חַ Using O365 v2505 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
macgregorga | Word Tables | 1 | 01-09-2020 09:51 PM |
![]() |
eNGiNe | Word | 4 | 10-18-2017 10:57 PM |
![]() |
NotSaying | Mail Merge | 3 | 09-27-2016 02:08 PM |
![]() |
DLeighC | OneNote | 1 | 09-05-2015 06:49 AM |
Repeating table rows in template? | TheWedgie | Word | 0 | 09-11-2010 09:35 PM |