Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 11-21-2023, 07:15 PM
Alansidman's Avatar
Alansidman Alansidman is offline Transform Repeating Rows into Column Headings Windows 11 Transform Repeating Rows into Column Headings Office 2021
עַם יִשְׂרָאֵל חַי
 
Join Date: Apr 2019
Location: Steamboat Springs
Posts: 112
Alansidman has a spectacular aura aboutAlansidman has a spectacular aura aboutAlansidman has a spectacular aura about
Default

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
File Type: xlsx Transform Columns.xlsx (21.9 KB, 7 views)
__________________
Alan עַם יִשְׂרָאֵל חַ Using O365 v2505
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Transform Repeating Rows into Column Headings Repeating Header Rows disappeared! macgregorga Word Tables 1 01-09-2020 09:51 PM
Transform Repeating Rows into Column Headings repeating two rows (including merge) as table heading eNGiNe Word 4 10-18-2017 10:57 PM
Transform Repeating Rows into Column Headings Repeating Section (Need Multiple values from different excel rows into one document) NotSaying Mail Merge 3 09-27-2016 02:08 PM
Transform Repeating Rows into Column Headings 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 01:41 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft