Reply To: Wainscoting Takeoff

  • Doug McLean

    Member
    May 17, 2023 at 10:52 am
    Points: 19,166
    Rank: UC2 Brainery Advanced Blue Belt IIII UC2 Brainery Advanced Blue Belt IIII

    @Vince … I’ve kicked this one up to a 12

    Doing this made me learn a few things. I made a few tools using the ; as a delimiter for the Label, then I got to thinking… could I do this for both the Label AND the Subject. Turns out I can.
    I had to learn a couple of new tricks in Power Query, but HOLY COW!!!!.

    It even works if I have a different number of delimiters.

    Me thinks a video is coming on how this is done.