Tranform CSV/Excel header value into a new column

[Anonymous]

Hi,

I have a source file coming as below with first 3 rows having the report details of topic, start time and other details.
Want to transform the topic from the row level and populate it as a column in dataset along with all the existing columns.(

the actual column headers are in row 6.)

I need the below marked which is Topic, start time and Report generated as new columns added and then remove  rows 1-5 after the tranformation.

we need the below marked which is Topic, start time and Report generated as column added and populated.

[MFelix]

Hi @Anonymous ,

For this you need to add 3 new columns and they must have the following syntax:

ReportGenerated Column

if [Column1] = "Report Generated:" then [Column2] else null

Topic Column 
if [Column1] = "Topic" then [Column3] else null

Vault Hour column
if [Column1] = "Vaul Hour" then [Column3] else null

Next step is toNow just select each column right click and select fill down on each of the values and you will get a full column with the values you need then just delete the other rows and put the headers has needed.