First Row as a column

[anillinda]

I have the following data :

Vendor name as the first row
The second row has the invoice number, amount and the amount outstanding.
The third, fourth and so on have the invoice numbers and then there is another vendor and invoice numbers.

I need to put the vendor number against the invoice number.
I would appreciate the help.

Ram01 RAM Enterprises
Invoice#02021	2530	10/15/2019
Invoice#02022	2680	11/20/2019

Thanks
Neal

 

[anillinda]

Yes, please this is the way I would like my data to be.
Thanks

 

[sandy666]

let
    Source = Excel.CurrentWorkbook(){[Name="Table13"]}[Content],
    IF = Table.AddColumn(Source, "Company", each if [Date] = null then [Number] else null),
    Fill = Table.FillDown(IF,{"Company"}),
    Filter = Table.SelectRows(Fill, each ([Date] <> null) and ([On Hold] = "N")),
    TSC = Table.SelectColumns(Filter,{"Company", "Number", "Date", "On Hold", "Total"})
in
    TSC

 

[anillinda]

works like a charm! But it is creating duplicate invoice numbers, though I was able to delete them by removing duplicate records.

 

[sandy666]

it is creating duplicate invoice numbers

for sure not, but it means your example was not representative
your found solution? Very good. but first check if your source data has a duplicated record

 

[anillinda]

If I were to import the file what would be the table name. Apparently it is not table1

 

[sandy666]

name will be added automatically
btw. use Excel nomenclature - there is no word "import"
if you have more questions - start new thread