I am experiencing an issue wherein an unwanted column of data is automatically being included in reports linked to a specific sheet.
When I create the report and link this specific sheet, the reports are automatically inserting the unwanted column of data. The unwanted column is not listed under the column dropdown and therefore cannot be removed. It is populating with a column header of "Primary". The Sheet Name column is also automatically populating but that column can be unchecked in the column dropdown and thus easily removed. I noticed that the unwanted column also does not appear in the filter dropdown selections. Otherwise, the unwanted column is a random column (like the 20th out of 100) in the original sheet. Screenshot attached below.
Ideas on how to address this issue?