Forum Discussion

Terrassa's avatar
Terrassa
Helper I
3 years ago
Solved

Convert a row into a column

Hello, Our payroll application can export the working time per day of all employees in this format: Date Start time End time John Smith     01/01/2023   8:00 17:03 01/02/2023   8...
Need Help
  • slorin's avatar
    slorin
    3 years ago

    Hi

     

    let
    Source = Your_Source,
    Name = Table.AddColumn(Source, "Name", each if [Start time] = null then [Date] else null),
    FillDown = Table.FillDown(Name,{"Name"}),
    Filter = Table.SelectRows(FillDown, each [Start time] <> null)
    in
    Filter

    Stéphane 

slorin's avatar
slorin
Super User
3 years ago

Hi

 

let
Source = Your_Source,
Name = Table.AddColumn(Source, "Name", each if [Start time] = null then [Date] else null),
FillDown = Table.FillDown(Name,{"Name"}),
Filter = Table.SelectRows(FillDown, each [Start time] <> null)
in
Filter

Stéphane