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

 

[sandy666]

Expected result? use XL2BB to show your example
your duplicated posts contain totally different example vs post #1

 

[anillinda]

The above data shows the screenshot from the actual data.

 

[sandy666]

re-read post#11 then post#1

 

[anillinda]

The invoice number does not have Invoice the beginning of the invoice number. Yes I agree I should have provided the actual data.
Sorry for the confusion ):

 

[anillinda]

The invoice numbers do not begin with word Invoice

 

[sandy666]

what about XL2BB ?

 

[sandy666]

something like this ?
but I'd like to see expected result

Company	Number	Date	On Hold	Total
AME03 AMERICAN EXPRESS	ER_AMEX_2019-2020_7	2/25/2020	N	13691.4
AME03 AMERICAN EXPRESS	ER_AMEX_2019-2020_8	3/25/2020	N	6360.78
AME03 AMERICAN EXPRESS	20052.18	6725	0	0
AMG01 AMERIGAS PROPANE	804635113	3/30/2020	N	179.25
AMG01 AMERIGAS PROPANE	179.25	179.25	0	0

 

[anillinda]

Yes

 

[anillinda]

The third row is the total row for all invoices, but the amount is shown under the row column.I would rather delete the row that totals the open invoices.
I appreciate your help.
God Bless!
Thanks
Neal

 

[sandy666]

you mean like this?

Company	Number	Date	On Hold	Total
AME03 AMERICAN EXPRESS	ER_AMEX_2019-2020_7	2/25/2020	N	13691.4
AME03 AMERICAN EXPRESS	ER_AMEX_2019-2020_8	3/25/2020	N	6360.78
AMG01 AMERIGAS PROPANE	804635113	3/30/2020	N	179.25