taylorg1820
New Member
- Joined
- Jun 2, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
I needed to use Power Query to reformat data into a table I can use for analysis. I wanted to add a column where I could type comments, which are typically pasted from a different source. For whatever reason, excel is not allowing me to paste anywhere in the power query table. I can paste anywhere in the sheet outside of the table, but as soon as I click in the table, the paste button is greyed out. Is there a way to do this? My end goal is to create self referencing tables so that I can manually add comments which are logically linked to the rows of data in the table (so when I sort the table the comments are still in the correct rows). How can I do this while still being able to use copy and paste?