Transform Repeating Rows into Column Headings

Alansidman · #1 11-21-2023, 07:15 PM

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"

ScottyBee75 · #2 11-22-2023, 02:49 PM

Thanks Alansidman as your solution worked out great. I know VBA but this Power Query syntax is foreign to me. Is the code you provided something you learned by doing several Power Queries or is their a library of code snippets somewhere that you can just copy and paste?

Thanks again

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