Results 1 to 1 of 1

Thread: PQ-Get each student list from each subject

  1. #1
    Sir Moderator sandy666's Avatar
    Join Date
    May 2018
    Posts
    238
    Rep Power
    7

    Cool PQ-Get each student list from each subject

    Source Result
    NAME Good at subject A Good at subject B Good at subject C Good at subject D Good at subject E language math English history geography
    ABC language math English history geography ABC ABC ABC ABC ABC
    CDE math geography HIJ CDE EFG EFG CDE
    EFG English math history EFG HIJ HIJ
    HIJ history geography language math HIJ XYZ
    XYZ math history XYZ


    Code:
    // Query1
    let
        Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
        UOC = Table.UnpivotOtherColumns(Source, {"NAME"}, "Attribute", "Value"),
        Grp = Table.Group(UOC, {"Value"}, {{"Count", each [NAME]}}),
        Result = Table.FromColumns(Grp[Count],Grp[Value])
    in
        Result
    Last edited by sandy666; 07-10-2023 at 02:25 PM.
    sandy
    I know you know but I forgot my Crystal Ball and don't know what you know also I may not remember what I did weeks, months or years ago so answer asap. Thinking doesn't hurt

Similar Threads

  1. Replies: 0
    Last Post: 10-17-2020, 04:25 PM
  2. Replies: 2
    Last Post: 09-03-2013, 11:00 PM
  3. Replies: 2
    Last Post: 07-28-2013, 09:29 AM
  4. Replies: 4
    Last Post: 07-27-2013, 01:34 PM
  5. Check for Missing Attachment and Subject in Outlook
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 05-17-2013, 12:32 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •