Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.07 seconds.

  1. Replies
    3
    Views
    116

    Re: power query running total help

    or try

    Running Total in PQ
  2. Replies
    3
    Views
    116

    Re: power query running total help

    expected result example?
  3. Replies
    6
    Views
    70

    Re: populate cells using

    maybe something like this with PivotTable


    Count of CourseCourse

    StudentIDEnglishFrenchMathScience

    a1
    1
    1
  4. Replies
    6
    Views
    84

    Re: New Group of Rows to a Table

    you can try PowerQuery (Get&TRansform)


    // WChart_Data
    let
    Source1 = Excel.CurrentWorkbook(){[Name="WChart_Data"]}[Content],
    Source2 =...
  5. Replies
    6
    Views
    84

    Re: New Group of Rows to a Table

    this is simply copy/paste and nothing to expand or I don't understand your logic
  6. Replies
    6
    Views
    84

    Re: New Group of Rows to a Table

    it seems like you want duplicate 12 last rows, am I right?
  7. Replies
    3
    Views
    45

    Re: Countifs formula

    sure

    have a nice day
  8. Replies
    3
    Views
    45

    Re: Countifs formula

    maybe ">="&AB4
  9. Replies
    1
    Views
    66

    Re: Sorry, We couldn't find...

    try PowerQuery (Get&Transform) with From Folder feature
  10. Replies
    7
    Views
    141

    Re: VLOOKUP help (not SUMIF)

    maybe use PivotTable


    PersonValueProductPersonSum of ValueProductSum of Value

    Person 1
    500Product 1Person 1
    1500Product 1
    1000
  11. Replies
    7
    Views
    185

    Re: Days and months into quarters

    this is not vba and this is not a macro
    if you've (PC) Excel 2010/2013 with PowerQuery add-in or 2016 and above you can try this M-code.
    (Power Query == Get&Transform)
    if not - it doesn't work
  12. Re: Allocating revenue cash blows on a straight line basis over a fixed period

    no problem
  13. Re: Allocating revenue cash blows on a straight line basis over a fixed period

    don't quote post if it is not really needed. use Reply instead of Reply With Quote.
    besides, I know what I wrote.
  14. Re: Allocating revenue cash blows on a straight line basis over a fixed period

    read Board FAQ / Guidelines
    or
    post a link to the shared excel file with representative example of source and expected result using OneDrive, GoogleDrive, DropBox or any similar
  15. Re: Allocating revenue cash blows on a straight line basis over a fixed period

    nothing attached
  16. Replies
    7
    Views
    185

    Re: Days and months into quarters

    you didn't show expected result so maybe this with PowerQuery


    DATESQuarter


    01/01/2019
    1
  17. Replies
    3
    Views
    91

    Re: How to group this in Pivot Tables

    you are welcome

    Have a nice day
  18. Re: Consolidating multiple rows into one single row - large data file

    you are welcome

    have a nice day
  19. Re: Consolidating multiple rows into one single row - large data file

    there is no any export
    there is Close&Load and you can choose where your query table will be placed or you can stay with query table as connection
    what you mean by : exported code?
    code, or rather...
  20. Replies
    3
    Views
    91

    Re: How to group this in Pivot Tables

    try with PowerQuery


    // Table1
    let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    UnPivot = Table.UnpivotOtherColumns(Source, {"Customer Name"}, "Attribute", "Value"),
    ...
  21. Re: Consolidating multiple rows into one single row - large data file

    How you get data into the sheet it's up to you

    if you've data in the sheet just use Ctrl+T (check table name in Name Manager)
    the rest you can do in PowerQuery Editor

    if your table has name...
  22. Replies
    8
    Views
    651

    Re: Insert New Row in Excel Power Query

    sure :laugh:

    have a nice day
  23. Re: Consolidating multiple rows into one single row - large data file

    is that what you want?

    Source:

    Business GroupLast NameFirst NameUNIDEmail AddressQuestionnaire TitleSectionQuestionResponseDate

    AdvisorySmithDavidxxxxxxxxxPropertyDisclosureWhat best...
  24. Replies
    8
    Views
    651

    Re: Insert New Row in Excel Power Query

    Header1Header2Header3Header4

    aabbccdd

    wweerrtt


    with Table.FromRecords
  25. Re: Find 2nd and 3rd highest numbers in a row and return column header

    maybe something like this:


    ETF-AETF-BETF-CETF-DMaxCustom


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