Results 1 to 6 of 6

PowerQuery - ignore data in a column?

Threaded View

  1. #1
    Forum Contributor NewYears1978's Avatar
    Join Date
    03-15-2010
    Location
    Forney, TX
    MS-Off Ver
    Excel 2016
    Posts
    962

    PowerQuery - ignore data in a column?

    This is a weird question probably. I have a simple table of columns. The data changes daily of course thus I use PowerQuery to keep other tabs updated based on criteria and this all works fine.

    However, one column in the data is a blank column that on each connection that column is for notes for the user to type in. However, when refreshing the data from the main tab which has blanks int he column it will overwrite any written notes they had put in. Is there a way to keep the existing data in a specific column?

    Wow this was harder to explain that I though. I used to do this in other ways, without using pivot tables but it was a mess, required vlookups and copying sheets and lots of macros - so I was trying to simplify this all using PowerQuery.

    I attached a small sample file.
    Basic premise:
    Sheet one "Quotes" is the data set that the queries are created from, it changes daily. The "Notes" column J is always blank here.
    There are two other sheets which are just Queries to the main table and pull in the data, but the "Notes" Column J on those tabs the user would be typing in data, and that data should REMAIN when refreshing the data.

    I am sure there is some simple way to do this, thanks in advance
    Sorry that my explanation is pretty awful haha.

    (For reference, the only solution I came up with might be to have a separate table that is all the notes from each of my sheets, and then using VLOOKUP on each sheet for the Quote Number on the Notes table, this will work just wanted to make sure there wasn't a better way)
    Attached Files Attached Files
    Last edited by NewYears1978; 07-29-2022 at 12:24 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] PowerQuery - return value in one column if certain values appear in another
    By SexySarah in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-23-2022, 03:36 AM
  2. [SOLVED] PowerQuery assist: Populate changing data into a new column
    By Iwasiw35 in forum Excel General
    Replies: 2
    Last Post: 06-03-2021, 06:18 PM
  3. [SOLVED] PowerQuery - Split column into multiple columns based on another column
    By Bassehave in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-20-2019, 09:48 AM
  4. PowerQuery Custom Column/Functions
    By Zer0Cool in forum Excel General
    Replies: 0
    Last Post: 02-22-2019, 04:53 PM
  5. Replies: 2
    Last Post: 01-23-2019, 07:00 PM
  6. [SOLVED] Converting a row into a column using PowerQuery
    By heytherejem in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-27-2018, 09:01 AM
  7. Ignore Blank column in source data for Column Chart.
    By guitmusic11 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-25-2015, 04:42 PM

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