Question

You import a CSV export from an accounting system into Power Query. The first data row contains descriptive labels like 'Acct No', 'Cost Center', and 'Amount', but Power Query has assigned generic names such as Column1, Column2, and Column3 to each column instead of using those labels. You need the query to use the descriptive labels as the column headers with the fewest steps. What should you do?

Accepted Answer

Apply the 'Use First Row as Headers' transform to promote the first row to header names

Answer

Manually rename each Column1, Column2, and Column3 by double-clicking each header

Answer

Add a custom column that references the first row's values as text

Answer

Use 'Transpose' twice to shift the label row into the header position