Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.07 seconds.

  1. Re: Can someone help me with this? Probably a beginner level formula.

    did you try a PivotTable?
  2. Replies
    6
    Views
    109

    Re: Match Function Problem

    sure

    What is PowerQuery?
  3. Replies
    6
    Views
    109

    Re: Match Function Problem

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

    you are welcome

    have a nice day
  5. 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
  6. Replies
    18
    Views
    584

    Re: Power Query column alignment

    you can try this


    let
    Source =...
  7. Replies
    18
    Views
    584

    Re: Power Query column alignment

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

    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...
  9. Replies
    18
    Views
    584

    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!
  10. Replies
    18
    Views
    584

    Re: Power Query column alignment

    is that what you want?

    first ten rows...

    ...
  11. Replies
    18
    Views
    584

    Re: Power Query column alignment

    I'll wait to see if the post#4 will work ;)
  12. Replies
    18
    Views
    584

    Re: Power Query column alignment

    you forgot about one thing: DataSource.Error: Could not find a part of the path 'C:\Users\Ben\Desktop\PQ\persons-with-significant-control-snapshot-2019-09-13.csv'.
  13. Re: how to divide and unique names in to one slicer

    I don't know
    Get it or forget it ;)
  14. Re: how to divide and unique names in to one slicer

    use PowerQuery
    split first column by delimiter ", " (comma space) to rows

    then you can:
    create PivotTable from Query Table and insert slicer
    or
    load Query Table to the sheet and insert slicer...
  15. Re: how to divide and unique names in to one slicer

    something like this?

    https://i.postimg.cc/5N35wTCD/slicer.jpg
  16. Re: how to stop auto show query table at refreshing

    see post#16

    but I can't help with vba or formula
  17. Re: Getting Power Query to add new values to the bottom

    to the merged table add custom column with mentioned function. it will give you date and time. sort ascending. remove this column.
    now you can add new data into your source table(s) and after...
  18. Re: how to stop auto show query table at refreshing

    maybe look at: https://contexturesblog.com/archives/2016/08/18/quick-ways-unpivot-excel-data/
  19. Re: how to stop auto show query table at refreshing

    the question is too general

    what does that mean: combine multiple columns?
    what you want to achieve before PivotTable?
  20. Re: how to stop auto show query table at refreshing

    you are welcome

    next time post your question about PowerQuery in a proper forum

    have a nice day
  21. Re: how to stop auto show query table at refreshing

    as I said before
    - Close&Load to...
    - Connection only
    then
    - Insert
    - Pivot Table
    - Use an external data source
    - Choose connection
    - select your Query Table
    - Open
  22. Re: how to stop auto show query table at refreshing

    try this

    https://1drv.ms/x/s!AopTvf3RGAN5kzb3xscazGFmOWFS?e=xsGntt
  23. Re: how to stop auto show query table at refreshing

    I said SHARE file and post a link to SHARED file

    Access to doc-14-6o-docs.googleusercontent.com was denied

    btw. do you want hide Query Table or hide columns in Query Table?

    if hide Query...
  24. Re: how to stop auto show query table at refreshing

    what is you excel version?

    edit:
    post representative example of source data and expected result - share excel file on Onedrive, GoogleDrive or any similar then post link here
  25. Re: how to stop auto show query table at refreshing

    remove these columns from Query Table
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4