Transform Repeating Rows into Column Headings

		Microsoft Office Forums > Microsoft Excel > Excel
Transform Repeating Rows into Column Headings

FAQ

Thread Tools

Display Modes

11-21-2023, 07:15 PM

Alansidman Alansidman is offline

Windows 11 Transform Repeating Rows into Column Headings

Office 2021

עַם יִשְׂרָאֵל חַי

Join Date: Apr 2019

Location: Steamboat Springs

Posts: 121

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"

Attached Files

Transform Columns.xlsx (21.9 KB, 8 views)

__________________
Alan עַם יִשְׂרָאֵל חַ Using O365 v2511

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:44 PM.