Forum Discussion
merging query
I am merging two queries into one worksheet, each has their own set of column headers. I wish to delete the header row on the merged query, but of course there is no way to do so, all delete functions are greyed out
CampMaster What do you mean by "all delete functions are greyed out" ?
Are you talking about Power Query? If so, to remove column headers you first need to demote the header (Use header as first row) and then remove the top 1 row.
