Autofill data from in excel

Jayanta85 

> https://support.microsoft.com/en-gb/office/create-load-or-edit-a-query-in-excel-power-query-ca69e0f0-3db1-4493-900c-6279bef08df4 a query in Excel

Edit query TableOut > From the Home tab choose Advanced Editor to see the query code:

let
    Source = TableIn,
    CombinedValues = Table.AddColumn(Source, "Values", each
        List.RemoveNulls(Record.ToList(_)), type list
    ),
    RemovedOtherColumns = Table.SelectColumns(CombinedValues,{"Values"}),
    ExtractedValuesAsString = Table.TransformColumns(RemovedOtherColumns,
        {"Values", each Text.Combine(List.Transform(_, Text.From), ";"), type text}
    ),
    SplitColumnByDelimiter = Table.SplitColumn(ExtractedValuesAsString, "Values",
        Splitter.SplitTextByDelimiter(";", QuoteStyle.Csv), Table.ColumnNames(Source)
    ),
    TypedColumns = Table.TransformColumnTypes(SplitColumnByDelimiter,
        List.Transform(Table.ColumnNames(Source), each {_, type number})
    )
in
    TypedColumns

PS: Marking one working option you got as Solution helps people who Search - Thanks