Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.08 seconds.

  1. Re: Pivot Table Filter For Multiple Survey Responses

    something like this?


    Teacher(All)



    Sum of ValueGrade

    Attribute
  2. Re: Pivot Table Filter For Multiple Survey Responses

    file is NOT shared
  3. Replies
    1
    Views
    38

    Re: Does Access support pivot tables now

    maybe it will help: PivotTable in Access2010 or Access2013
  4. Replies
    3
    Views
    99

    Re: SQLITE Integration

    You are welcome

    there is export to Excel, CSV and some more...

    Have a nice day
  5. Replies
    3
    Views
    99

    Re: SQLITE Integration

    maybe SQLite2009 Pro 3.8 (free)
  6. Re: Power Query Does Not Import Multiple PDF Pages

    You are welcome

    Impatient person :laugh:

    have a nice day
  7. Re: Power Query Does Not Import Multiple PDF Pages

    my fault :)

    right click on the first binary - add as new query then dbl click on the file icon
    back to the top
    right click on the second binary - add as new query then dbl click on the file...
  8. Re: Power Query Does Not Import Multiple PDF Pages

    try this way:

    Folder
    Load
    on the left click Data icon
    Edit Queries
    Remove rows
    right click Binary (column content)
    Drill down
    Column Data
  9. Re: Power Query Does Not Import Multiple PDF Pages

    because there are columns of the tables
    Expand all
    then transform/clean data and stay with data what you need

    PBD (PQ) is not a Click&Go, sometimes you need to know what are you want to achieve...
  10. Re: Power Query Does Not Import Multiple PDF Pages

    https://i.postimg.cc/Y0rSCC2J/screenshot-112.png

    TransformData (post#6) == Transform

    btw. I know what is there so describe what are you doing only not whole layout
  11. Re: Power Query Does Not Import Multiple PDF Pages

    remove not necessary rows then TransformData and choose from Attribute columns you need
  12. Re: Power Query Does Not Import Multiple PDF Pages

    Yes I see as I said before

    Just because :) :) :) it's too heavy and problem with high resolution. All what I need I have in Excel: PQ, PowerPivot

    Right PQ in Excel cannot but there is a few...
  13. Re: Power Query Does Not Import Multiple PDF Pages

    I connect pdf with over 800 pages (tables) and it works well
    but PBD is useless to me :lol:
  14. Re: Power Query to Concatenate Rows Based on Condition

    nevermind? :)
  15. Re: Power Query to Concatenate Rows Based on Condition

    no prob...
  16. Re: Power Query to Concatenate Rows Based on Condition

    After Group you should see Table column, then use
    for ID: ID = Table.AddColumn(Group, "ID", each List.Distinct(Table.Column([Count],"ID"))),
    and : ExtractID = Table.TransformColumns(ID, {"ID",...
  17. Re: Power Query to Concatenate Rows Based on Condition

    Use Group with All Rows then List.Distinct and Extract with Space delimiter


    NameIDAddressNameIDAddress

    Joe Smith
    12325 Apple DrJoe Smith12325 Apple Dr New York City, NY, 00972

    Joe Smith...
  18. Re: Replacing/Adding text in a different column

    it looks like Merge option but without representative example data of source and expected result it's hard to say something more
  19. Replies
    8
    Views
    156

    Re: Breaking split at not 0

    It's info from MS site, I won't argue with MS :)

    Link: Base()
  20. Replies
    8
    Views
    156

    Re: Breaking split at not 0

    BASE function

    Excel for Office 365 Excel for Office 365 for Mac Excel for the web Excel 2019 Excel 2016 Excel 2019 for Mac Excel 2013 Excel 2016 for Mac Excel for Mac 2011

    Post #1 does not...
  21. Replies
    8
    Views
    156

    Re: Breaking split at not 0

    or A2: =BASE(A1+4,10,8) where A1: 00000001
  22. Re: Power Query - Dynamic Column Headers - By Date

    I am glad you solved your problem

    Have a nice day
  23. Re: Power Query - Dynamic Column Headers - By Date

    Post representative example of source data and expected result
  24. Replies
    13
    Views
    585

    Re: In Power Query - Decimals getting removed

    ok, no problem
  25. Re: Match multiple values from one column with single value from other column

    You are welcome

    Have a nice day :)
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4