+ Reply to Thread
Results 1 to 2 of 2

Adding column in a query table

  1. #1
    Registered User
    Join Date
    07-06-2020
    Location
    Denmark
    MS-Off Ver
    Microsoft 365
    Posts
    12

    Adding column in a query table

    Hi all,

    I have 3 tabs in an excel sheet with same format and headers in a table form, from where I am pulling the data through appending query and putting it in a new tab with some filters to see only filtered data.

    I want to add a new column on the right most side in this newly made table to write any comments, which I did.
    Now when I update the table after I changed something in one of the first 5 tabs, of course the query table will get updated but the comments section in newly added column remains static, which means they stay in the same cell where i have put them. Is there a way the comments cell remains attached to the row where the comment was put in the first time, being dynamic?

    Thanks in advance.

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

    Re: Adding column in a query table

    I believe the column needs to added to the original data to maintain the row integrity. It cannot be added after the query as it is the native Excel and not part of the query.
    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. Macro for Power Query? (adding column)
    By elbrujo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-18-2019, 05:11 PM
  2. Adding Column in Power Query
    By fuerte in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-28-2018, 12:39 PM
  3. Adding Column in Power Query
    By fuerte in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-28-2018, 11:15 AM
  4. Adding data to the end of a table with Power Query
    By afila in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-14-2016, 08:29 AM
  5. Importing CSV Files without adding a new query table
    By NatalieEC in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-14-2015, 03:38 PM
  6. Replies: 0
    Last Post: 12-05-2012, 03:48 PM
  7. SQL help adding a value in a query table
    By st0kvis in forum Access Programming / VBA / Macros
    Replies: 1
    Last Post: 01-24-2012, 05:40 AM

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