merging query

Copper Contributor

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

1 Reply

@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.