Promoting first row as headers (Power Query) - Minor issue

[stockmarket123]

Hi there

I am using Power Query to import some standard customer payment reports (csv format) and then clean them up further.

The customer payment reports would be in the following format: The first 6 rows would describe the payment file in general (eg. Payment reference #:, date of deposit:, payee number:, etc) followed by multiple rows of all the invoices and $ amounts of the invoices.

After using a conditional column to extract the "payment reference#" and the "date of deposit" into new columns, I promote the first row as headers so that my columns are properly named.

The issue I am having: Since the payment reference # and the date of deposit are already shown as headers, it gets replaced by the actual data itself. For example, "1020362" and "30-JUL-2018" would show up in the column header incorrectly. All the other columns have the correct header information (eg. Invoice No., Invoice Amt) except these 2 aforementioned columns.

Is there any workaround solution? Please keep in mind I am not a coder by any means, so hopefully the solution is within the actual Power Query GUI.

Thank you

Winston

 

[stockmarket123]

okay..thank you so much..

yes..that was my fault, I should have made the source available as well..

Anyways, the helper table does work as well

 

[sandy666]

One more thing
use helper table after all what you want to do with your query table
headers of the helper table and query table must be exactly the same, if not - your table will be destroyed
in the second row of helper table you can use whatever you want , even : xxx movie name but in this case I copied names from 8th row, added the names from original headers (first column and two last columns)

can I delete file from the server?

 

[stockmarket123]

yes...please delete from server...much appreciated for your expertise.

 

[sandy666]

ok, deleted

Have a nice day