Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.07 seconds.

  1. Re: Pivot Table Filter For Multiple Survey Responses

    you will need PowerQuery aka Get&Transform

    use Data tab, select whole source table, then on the ribbon From Table, it will open PQ Editor, select all Q columns, from the PQ Editor ribbon choose...
  2. Re: Pivot Table Filter For Multiple Survey Responses

    so choose the post you want :)
  3. Re: Pivot Table Filter For Multiple Survey Responses

    like this one?


    Teacher(All)

    AttributeQ1



    Count of ValueGrade
  4. Re: Pivot Table Filter For Multiple Survey Responses

    or this


    Teacher(All)



    Count of ValueGradeValue
  5. Re: Pivot Table Filter For Multiple Survey Responses

    something like this?


    Teacher(All)



    Sum of ValueGrade

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

    file is NOT shared
  7. Replies
    1
    Views
    79

    Re: Does Access support pivot tables now

    maybe it will help: PivotTable in Access2010 or Access2013
  8. Replies
    3
    Views
    102

    Re: SQLITE Integration

    You are welcome

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

    Have a nice day
  9. Replies
    3
    Views
    102

    Re: SQLITE Integration

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

    You are welcome

    Impatient person :laugh:

    have a nice day
  11. 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...
  12. 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
  13. 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...
  14. 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
  15. Re: Power Query Does Not Import Multiple PDF Pages

    remove not necessary rows then TransformData and choose from Attribute columns you need
  16. 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...
  17. 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:
  18. Re: Power Query to Concatenate Rows Based on Condition

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

    no prob...
  20. 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",...
  21. 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...
  22. 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
  23. Replies
    8
    Views
    159

    Re: Breaking split at not 0

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

    Link: Base()
  24. Replies
    8
    Views
    159

    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...
  25. Replies
    8
    Views
    159

    Re: Breaking split at not 0

    or A2: =BASE(A1+4,10,8) where A1: 00000001
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4