Combine and filter multiple Date/Time and data columns

HI Anonymous,

Is below outcome what you're looking for?

I need to re-write part of the code to make it dynamic if this is what you are after.

Code:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],

    //Only keep two Date/Time Columns
    KeepDateTime = Table.RemoveColumns(
                        Source, 
                        List.RemoveFirstN(
                            List.Select(
                                Table.ColumnNames(Source), 
                                each 
                                    Text.Contains(_,"Time")
                            ),
                            2
                        )
                    ),

    //Renamed the two Date/Time columns to Date & Time
    RenamedDateTime = Table.RenameColumns(
                            KeepDateTime, 
                            List.Transform(
                                List.Select(
                                    Table.ColumnNames(KeepDateTime), 
                                    each 
                                        Text.Contains(_,"Time")
                                ), 
                                each 
                                    {_, if Text.StartsWith(_,"Part 2") 
                                        then "Time" 
                                        else "Date"
                                    }
                            )
                        ),

    //Reordered columns to Date, Time, Part 1, 2 3 ....
    ReorderedCol = Table.ReorderColumns(
                        RenamedDateTime, 
                        {"Date", "Time"} & List.Select(
                                                Table.ColumnNames(RenamedDateTime), 
                                                each 
                                                    _<>"Time" and _<>"Date"
                                            )
                    ),

    //Changed Data Type Date & Time
    #"Changed Type" = Table.TransformColumnTypes(
                            ReorderedCol,
                            {
                                {"Date", type date}, 
                                {"Time", type time}
                            }
                        ),

    //Demote headers before transpose
    DemotedHdrs = Table.DemoteHeaders(#"Changed Type"),

    //Transpose Table
    TransposedTbl = Table.Transpose(DemotedHdrs),

    //Add label - "Equipment x" (required to rewrite this part to make it dynamics label)
    CombineTbls = Table.Combine({#table({"Column1"},{{"Equipment 1:"}}),TransposedTbl})
in
    CombineTbls

Regards

KT 

The data provided is a small sample from 1 equipment. Once I can figure out 1 of them I can then apply it to the others.

The first screenshot shows that the times are not the same so it's not possible to just delete the extra date/time columns.

So I want to only have 1 date column and one time column per equipment. Each equipment has 8 parts and each part has its own set of Date/Time. You could make each part into its own table, but then you would have too many tables (20 equipment * 8 parts = 160 tables). So in my reply I tried giving an example of how I am trying to organize it. 

1. Each equipment has its own table

2. Each table has 8 parts

3. Each table has 1 Date and 1 time column