Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.07 seconds.

  1. Re: Cannot see individual dates in Pivot Table (gets grouped to months automatically)

    Excel Options - Advanced - Data - Disable automatic grouping of Date/Time columns in Pivot Table (checked)
    then re-create PT
  2. Re: Power Query: Removing duplicate values in Multi-Value Cells

    you are welcome

    maybe time to learn more about PowerQuery


    What is PowerQuery
    Getting started with PQ
    PowerQuery Help
    PowerQuery M reference
  3. Re: Power Query: Removing duplicate values in Multi-Value Cells

    Change source range to table (Ctrl+T), - be sure the name of the table is the same as in the code - in this case : Table1
    then use From Table (Get&Transform part on the ribbon)
    then open Advanced...
  4. Replies
    1
    Views
    40

    Re: Cannot filter by months in Pivot Table

    maybe:
    Report Layout - Show in tabular form
    then filter by month
  5. Re: Power Query: Removing duplicate values in Multi-Value Cells

    try


    // Table1
    let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Group = Table.Group(Source, {"Column1"}, {{"Count", each _, type table}}),
    List =...
  6. Replies
    20
    Views
    858

    Re: Power Query column alignment

    you are welcome

    use solution with Parsed JSON, much easier and faster (with whole 5 GB file)

    have a nice day
  7. Replies
    3
    Views
    144

    Re: Calculation of Net Working days

    look at few posts later
    there is networkdays with hoildays
  8. Replies
    3
    Views
    144

    Re: Calculation of Net Working days

    see: Networkdays
  9. Re: Can someone help me with this? Probably a beginner level formula.

    worth to read:

    PowerQuery aka Get&Transform (links):

    What is PowerQuery
    Getting started with PQ
    PowerQuery Help
    PowerQuery M reference
  10. Re: Getting Power Query to add new values to the bottom

    you are welcome

    have a nice day
  11. Re: Can someone help me with this? Probably a beginner level formula.

    nothing wrong :)

    all what you need is Append all single tables into one (Power Query) then create Pivot Table
  12. Re: Can someone help me with this? Probably a beginner level formula.

    I give up :diablo:

    Have a nice day
  13. Re: Can someone help me with this? Probably a beginner level formula.

    or Power Query :) :) :)
    or even Power Pivot
  14. Re: Can someone help me with this? Probably a beginner level formula.

    all your needs from the first post to now you can do in just PivotTable

    enough to read about: Pivot Table and some more links there.

    or even change your range to Excel Table (Ctrl+T) , add...
  15. Re: Can someone help me with this? Probably a beginner level formula.

    I'll ask again: what about PivotTable?
  16. Re: Can someone help me with this? Probably a beginner level formula.

    did you try a PivotTable?
  17. Replies
    6
    Views
    121

    Re: Match Function Problem

    sure

    What is PowerQuery?
  18. Replies
    6
    Views
    121

    Re: Match Function Problem

    IMHO PowerQuery (Get&Trannsform) would help
  19. Re: Combining 2 lists (for each cell in first list assign all cells in second list)

    you are welcome

    have a nice day
  20. Re: Combining 2 lists (for each cell in first list assign all cells in second list)

    or with PowerQuery aka Get&Transform


    table1table2table1table2

    austinappleaustinapple

    justinbananaaustinbanana

    paulorangeaustinorange
  21. Replies
    20
    Views
    858

    Re: Power Query column alignment

    you can try this


    let
    Source =...
  22. Replies
    20
    Views
    858

    Re: Power Query column alignment

    it takes some time with ca. 5 GB of data (sorry, I didn't check unzipped file size :))
  23. Replies
    20
    Views
    858

    Re: Power Query column alignment

    use Reply not Reply With Quote :)

    https://i.postimg.cc/g2gzkLK5/screenshot-106.png

    your previous source is incorrect because there is no company number, address lin1, etc... , I am trying with...
  24. Replies
    20
    Views
    858

    Re: Power Query column alignment

    this is 868 MB not 5 GB :)

    use header names what you want split/concatenate

    and don't quote whole post, please!
  25. Replies
    20
    Views
    858

    Re: Power Query column alignment

    is that what you want?

    first ten rows...

    ...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4