Hi Excel Experts,
I have attached a document as a example.
I have these invoices that are exported from my software. Depending on how much items we order, will depend how many rows are on the excel document.
I need to move (the highlighted part) to the left. I need to do this, because I plan on using another formula which is going to reference the whole column. (and I don't want the subtotal part messing up my other formula).
If someone can help me move those columns to the left in a formula or apple script
that would solve this issue. Thanks!
P.S. The formula must work for both sheets on the workbook. Since some orders will have one product; while others will have 15 products etc.... Example2.xlsx