Copy header column only

[anantv]

Hello,

My data table has more than 100 columns. I would like to just copy column headers and paste into excel and verify column names with another table. 

How do I just copy column headers only? I have been using 'copy table' and just keeping column headers only for verification.

Thanks

[BA_Pete · Accepted solution]

Hi @anantv ,

In Power Query, just create a new blank query and paste this over the default code in Advanced Editor:

let
    Source = Table.ColumnNames(queryName)
in
    Source

...where 'queryName' is the name of the query that you want the list of column names for.

Pete

[anantv]

Pete,

Thank you very much. This is exactly the solution, that I needed.

Thanks

[rubayatyasmin]

Hi, @anantv 

Assuming you are using Power BI.

1. Just export the table to csv. open the file, the first row should contain column names, just select the first row or the row that contains column names then copy paste it. 

or 

1. Go to Edit Queries > Transform > Structured Column > Expand to New Rows.
2. Then, go to Home > Keep Rows > Keep Top Rows > 1.
3. Apply & Close

this will only have column names. 

[anantv]

Hi Rubayatyasmin,

Thank you for the response. 

I had been extracting column names as option 1.

I was not able to use the second option (seems very interesting) as Structured column menu grouping is not available in my organization's O365 Power BI.

I appreciate your help. Thanks.