Page 2 of 5 FirstFirst 1234 ... LastLast
Threads 21 to 40 of 82

Forum: ETL PQ Tips and Tricks

Extract, Transform, Load Tools, Power Query, Power Pivot and Power BI Tips and Tricks

  1. Cool Sticky Thread Sticky: more about PowerQuery aka Get&Transform (links)

    Started by sandy666, 06-10-2020 07:43 PM
    • Replies: 0
    • Views: 7,488
    sandy666
    06-10-2020, 07:43 PM Go to last post

  1. Cool PQ-Enter blank row after group of cells or empty cell is detected

    Started by sandy666, 07-11-2023 04:12 PM
    • Replies: 0
    • Views: 609
    sandy666
    07-11-2023, 04:12 PM Go to last post

  2. Cool PQ-transpose data from several lines to one column

    Started by sandy666, 07-11-2023 04:05 PM
    • Replies: 0
    • Views: 492
    sandy666
    07-11-2023, 04:05 PM Go to last post

  3. Cool PQ - Concatenation by condition (XL2016)

    Started by sandy666, 07-11-2023 03:59 PM
    • Replies: 0
    • Views: 708
    sandy666
    07-11-2023, 03:59 PM Go to last post

  4. Cool PQ - Extracting data from range

    Started by sandy666, 07-11-2023 03:49 PM
    • Replies: 0
    • Views: 600
    sandy666
    07-11-2023, 03:49 PM Go to last post

  5. Cool PQ-Auto filling information

    Started by sandy666, 07-11-2023 02:10 PM
    • Replies: 0
    • Views: 552
    sandy666
    07-11-2023, 02:10 PM Go to last post

  6. Cool PQ - How to add columns from a list? each item in a list means a new column

    Started by sandy666, 07-11-2023 03:58 AM
    • Replies: 2
    • Views: 2,290
    sandy666
    07-11-2023, 04:01 AM Go to last post

  7. Cool PQ - serpentine volleyball seeding

    Started by sandy666, 07-10-2023 10:32 PM
    • Replies: 0
    • Views: 652
    sandy666
    07-10-2023, 10:32 PM Go to last post

  8. Cool PQ-text split multiple columns at once

    Started by sandy666, 07-10-2023 09:24 PM
    • Replies: 0
    • Views: 505
    sandy666
    07-10-2023, 09:24 PM Go to last post

  9. Cool PQ-Transposing Data and Splitting Cells

    Started by sandy666, 07-10-2023 09:07 PM
    • Replies: 0
    • Views: 563
    sandy666
    07-10-2023, 09:07 PM Go to last post

  10. Cool PQ- End of previous month

    Started by sandy666, 07-10-2023 08:13 PM
    • Replies: 0
    • Views: 653
    sandy666
    07-10-2023, 08:13 PM Go to last post

  11. Cool PQ - Table replace values

    Started by sandy666, 07-10-2023 06:33 PM
    • Replies: 0
    • Views: 709
    sandy666
    07-10-2023, 06:33 PM Go to last post

  12. Cool PQ-compare two columns A and B in the same table then return unmatched

    Started by sandy666, 07-10-2023 02:23 PM
    • Replies: 0
    • Views: 799
    sandy666
    07-10-2023, 02:23 PM Go to last post

  13. Cool PQ-Get each student list from each subject

    Started by sandy666, 07-10-2023 01:18 PM
    • Replies: 0
    • Views: 867
    sandy666
    07-10-2023, 01:18 PM Go to last post

  14. Cool PQ - Split multiple columns into rows at once

    Started by sandy666, 01-30-2023 10:07 PM
    power query
    • Replies: 0
    • Views: 2,276
    sandy666
    01-30-2023, 10:07 PM Go to last post

  15. Cool New old qeustion

    Started by sandy666, 02-15-2021 09:19 AM
    • Replies: 0
    • Views: 555
    sandy666
    02-15-2021, 09:19 AM Go to last post

  16. Cool PQ - How to append three or more tables with different headers (first table has proper headers)

    Started by sandy666, 01-20-2021 03:24 AM
    • Replies: 0
    • Views: 1,808
    sandy666
    01-20-2021, 03:24 AM Go to last post

  17. Cool PQ - Distinct keywords from text

    Started by sandy666, 01-04-2021 08:46 AM
    • Replies: 0
    • Views: 1,785
    sandy666
    01-04-2021, 08:46 AM Go to last post

  18. Cool PQ - extract 8-digit groups from a text string into separate columns

    Started by sandy666, 10-31-2020 11:16 PM
    • Replies: 0
    • Views: 1,898
    sandy666
    10-31-2020, 11:16 PM Go to last post

  19. Cool PQ - IP C class generator

    Started by sandy666, 10-22-2020 05:16 AM
    • Replies: 0
    • Views: 1,724
    sandy666
    10-22-2020, 05:16 AM Go to last post

  20. Cool PQ - Expand IP address range to individual

    Started by sandy666, 10-21-2020 12:36 PM
    • Replies: 0
    • Views: 1,485
    sandy666
    10-21-2020, 12:36 PM Go to last post
Page 2 of 5 FirstFirst 1234 ... LastLast

Forum Information and Options

Moderators of this Forum

Thread Display Options

Use this control to limit the display of threads to those newer than the specified time frame.

Allows you to choose the data by which the thread list will be sorted.

Order threads in...

Note: when sorting by date, 'descending order' will show the newest results first.

Icon Legend

Contains unread posts
Contains unread posts
Contains no unread posts
Contains no unread posts
More than 15 replies or 150 views
Hot thread with unread posts
More than 15 replies or 150 views
Hot thread with no unread posts
Closed Thread
Thread is closed
Thread Contains a Message Written By You
You have posted in this thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules