Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.07 seconds.

  1. Replies
    1
    Views
    38

    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"),
    ...
  2. 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...
  3. Replies
    8
    Views
    330

    Re: Insert New Row in Excel Power Query

    sure :laugh:

    have a nice day
  4. 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...
  5. Replies
    8
    Views
    330

    Re: Insert New Row in Excel Power Query

    Header1Header2Header3Header4

    aabbccdd

    wweerrtt


    with Table.FromRecords
  6. 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
  7. Re: How to extract only first 2 items, from different groups in the same data, meeting certain criteria

    maybe it's time to learn PowerQuery? :biggrin:

    anyway, good luck with formula

    Have a nice day
  8. Re: How to extract only first 2 items, from different groups in the same data, meeting certain criteria

    with PowerQuery aka Get&Transform


    // Table1
    let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Filter = Table.SelectRows(Source, each ([Status] = "Active" or [Status] =...
  9. Re: How to extract only first 2 items, from different groups in the same data, meeting certain criteria

    something like this?


    Country CodeShop ID


    4101
    4101002
  10. Replies
    11
    Views
    128

    Re: How to create double vlookup in Excel?

    If you say so...

    Have a nice day
  11. Replies
    11
    Views
    128

    Re: How to create double vlookup in Excel?

    use PowerQuery (Get&Transform) with Merge feature
  12. Re: Why is LOOKUP result changing - sometimes to wrong answer

    but you can post a link to the shared excel file with representative example and expected result using OneDrive, GoogleDrive or any similar
  13. Replies
    10
    Views
    185

    Re: I need with my friend

    maybe:


    A
    B
    C
    D
    E
    F
    G
  14. Replies
    12
    Views
    333

    Re: String Function

    another way with PowerQuery (Get&Transform)


    InputText

    AbST/1234342AST

    Y_sRR/666YRR

    B.RE/1234BRE
  15. Replies
    3
    Views
    69

    Re: Merge/Combine Rows Help

    try PowerQuery (Get&Transform) with Group feature and SUM option for values
  16. Re: Consolidating multiple rows into one single row - large data file

    Sure, I hope this will not be a picture :)
  17. Re: Consolidating multiple rows into one single row - large data file

    without representative example with structure and expected result I can say try PowerQuery with Group feature
  18. Re: Minimum of the multiple dates for a Product

    You are most welcome

    Have a nice day
  19. Re: Minimum of the multiple dates for a Product

    you can try PowerQuery (Get&Transform)


    let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Product", type text},...
  20. Replies
    8
    Views
    330

    Re: Insert New Row in Excel Power Query

    or Table.InsertRows(...)
  21. Re: Unstack data , grouping by ID complex problem

    Just tick Thanks and Like in the post which helped you :)
  22. Replies
    4
    Views
    95

    Re: Consolidating rows

    another way with PowerQuery


    GroupField1Field2Field3Field4GroupField1Field2Field3Field4


    1aaaaaa
    1
    1aaaaaa
    4
  23. Replies
    8
    Views
    330

    Re: Insert New Row in Excel Power Query

    as I said, Append new single row table with original table and you'll see new row as first in a brand new table

    if you want reverse rows in your original table then reverse before Append then...
  24. Replies
    4
    Views
    95

    Re: Consolidating rows

    it must be a vba?

    and you did mistake in the result, should be 93 not 13
  25. Replies
    8
    Views
    330

    Re: Insert New Row in Excel Power Query

    use Table.FromRecords to create Table with single row with Summer in the first column then Append this table with your original table
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4