Search:

Type: Posts; User: sandy666; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    5
    Views
    67

    Re: Convert a list into rows

    with PowerQuery (Get&Transform)


    rawCompanyAddress.1Address.2Address.3Address.4

    Company ACompany AThe High StreetBig TownAA1 3AA

    The High StreetCompany BThe MewsMain RoadLittle TownAA5 5AA...
  2. Replies
    13
    Views
    165

    Re: UN-pivoting a pivoted range

    You are welcome

    Have a nice day

    note:
    Example with the last M-code
  3. Replies
    13
    Views
    165

    Re: UN-pivoting a pivoted range

    ok, try this:


    // Table1
    let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Group = Table.Group(Source, {"Name From"}, {{"Count", each _, type table}}),
    List1 =...
  4. Replies
    13
    Views
    165

    Re: UN-pivoting a pivoted range

    post example excel file with real structure of data
  5. Replies
    13
    Views
    165

    Re: UN-pivoting a pivoted range

    MARK858

    Thanks

    capson

    could you answer for post #4 ?

    PowerQuery (Get&Tranaform) Excel 2010 and higher
  6. Replies
    13
    Views
    165

    Re: UN-pivoting a pivoted range

    maybe


    Name FromName ToTypeName FromName To.1Type.1Name To.2Type.2Name To.3Type.3Name To.4Type.4Name To.5Type.5

    Alisa MoralesElwood Iglesiasvalue twoAlisa MoralesElwood Iglesiasvalue two
    ...
  7. Re: Excel formula to rearrange the cell contents ENG/DEF/001/14 to ENG/DEF/14/001

    but which one?
  8. Re: Golf majors; retreive data from Wikipedia articles

    I don't know Golf, I know Data :)
    so I don't know what you want to achieve
    but you've start position - the rest is transforming only
  9. Re: Excel formula to rearrange the cell contents ENG/DEF/001/14 to ENG/DEF/14/001

    with PowerQuery (Get&Transform)


    rawresult

    ENG/DEF/001/14ENG/DEF/14/001



    // Table1
  10. Replies
    12
    Views
    174

    Re: Calculating mumber of incidents per month

    this is PowerQuery (Get&Transform) for Excel 2010 and higher

    you need create table (Ctrl+T) as you see Blue table, then load it to PQ Editor and adapt M-code to your needs and next load result...
  11. Re: Transpose and group? How do i transpose one column into multiple rows base on value in another column

    You are welcome
  12. Replies
    12
    Views
    174

    Re: Calculating mumber of incidents per month

    or


    Column1Column2Column3Column4Column5Column6Column7Column8Column9Column10Column11Column2Count

    Farnborough
    03/01/2019Slip. Trip from HeightEmployeeMinorAberdeen
    0Incl HO
    49January
    12
  13. Re: Transpose and group? How do i transpose one column into multiple rows base on value in another column

    try


    // Table1
    let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Group = Table.Group(Source, {"Column1"}, {{"Count", each _, type table}}),
    List =...
  14. Re: Golf majors; retreive data from Wikipedia articles

    and end result :)


    1988DatesJune 1620, 1988

    1988LocationBrookline, Massachusetts

    1988Course(s)The Country Club
    Composite Course
  15. Replies
    5
    Views
    73

    Re: How to convert date to Month/Year only

    probably your dates are as text
    try text to columns then set custom format : mm-yyyy
  16. Re: Is there a way to calculate SUMPRODUCT for an array and a number?

    or


    A
    B
    C
    D
    E

    1
  17. Re: Golf majors; retreive data from Wikipedia articles

    in single table for all years
    here is just breakthrough between 1986 and 1987


    1987Tournament informationTournament information

    1987DatesJune 1821, 1987

    1987LocationSan Francisco,...
  18. Re: how to create stacked bar for schedule/utilization

    ignore post#2
  19. Re: how to create stacked bar for schedule/utilization

    something like this?


    IDStart timeExam DurationIDDurationTot


    1
    11:20
    01:18
    1
  20. Re: Golf majors; retreive data from Wikipedia articles

    After posting I realized structure of the tables are different but as I can see you almost solved the problem
    You didn't say what you are tryin' to achieve so M-code is simply for each single year...
  21. Re: Golf majors; retreive data from Wikipedia articles

    structure of the tables before 1987 is different than >=1987


    SelectTitleLabelDetail


    1897Tournament informationDatesSeptember 17, 1897


    1897Tournament informationLocationWheaton, Illinois
  22. Re: Golf majors; retreive data from Wikipedia articles

    maybe something like this:


    // Select
    let
    Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    #"Invoked Custom Function" = Table.AddColumn(Source, "fnUSOpen", each...
  23. Re: Golf majors; retreive data from Wikipedia articles

    maybe from here: https://en.wikipedia.org/wiki/U.S._Open_(golf)
  24. Re: Average ifs for filtered data (visible data)

    you can post a link to shared excel file with source data and expected result. use OneDrive, GoogleDrive or any similar.
  25. Replies
    9
    Views
    248

    Re: TEXT IN A PIVOT TABLE's VALUE FIELD

    You can't because in Values Area your code will be counted
    Try to put NAME and CODE into Rows Area, choose Report Layout in Tabular Form

    https://i.postimg.cc/dtfKP454/screenshot-78.png
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4