+ Reply to Thread
Results 1 to 2 of 2

Power Query/ Get and Transform Merge Columns if then else combined

  1. #1
    Registered User
    Join Date
    03-12-2019
    Location
    DC Metro
    MS-Off Ver
    Excel 2016
    Posts
    1

    Power Query/ Get and Transform Merge Columns if then else combined

    I have several rows of data with part sizes and specifications. I'd like to merge columns based on the value in the column. I'm hitting a wall building this out in a custom column in Power Query.

    The "size" column can only be "large" or "small". If the column is "large" then I need only this value in the new column. If the value is "small" then I need "small" and the column values 1-7 when they are not equal to "N".

    I've merged all column and then began manually replaces the values for "N" and but there's endless possibilities so I'm hoping for an easier conditional custom formula.

    Attached is a sample of the desired results.
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,864

    Re: Power Query/ Get and Transform Merge Columns if then else combined

    HEre is the Mcode

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Get and Transform (Power Query) - Grouping numbers into bands/buckets
    By TheNewUnion in forum Excel General
    Replies: 2
    Last Post: 03-12-2019, 05:37 AM
  2. Power Query (Get & Transform) on Mac
    By SHI.NL in forum Excel General
    Replies: 2
    Last Post: 05-18-2018, 09:24 AM
  3. [SOLVED] Power Query / Get & Transform - filter text contains based on list
    By SHI.NL in forum Excel General
    Replies: 8
    Last Post: 05-14-2018, 04:53 PM
  4. [SOLVED] Power Query / Get & Transform filtering on text
    By SHI.NL in forum Excel General
    Replies: 5
    Last Post: 04-28-2018, 11:50 AM
  5. Replies: 3
    Last Post: 04-20-2018, 08:30 AM
  6. [SOLVED] Change data structure using Formula or Power Query ( Get & Transform)
    By chullan88 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-04-2017, 02:58 AM
  7. Get & Transform (Power Query) not showing certain tables
    By BamBamMoneyBags in forum Excel General
    Replies: 0
    Last Post: 03-22-2017, 12:22 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1