Help with if statement containing a sort function

[dallash]

I am not sure if that exactly what I am trying to do but ultimately I am trying to make an end of day sheet. It would only have 3 worksheets.

The cover would be the printable page split into 3 payment methods credit, paypay and store credit. I would collect all this information form the following to reports that I would paste in each day.

COVER PAGE

Order ID	NS Document Number	Subtotal (inc tax)	Subtotal (ex tax)	Tax Total	Shipping Cost (inc tax)	Shipping Cost (ex tax)	Coupon Details	Refund Amount	Customer Name	Payment Method	Store Credit Redeemed
Stripe
Paypal
Charge account

Page two is the sales report from my online store for containing the order id in column A which would be the value used to lookup all other information. Column J contains the Payment Method. Depending the payment method I would need the value from column A to populate on on the first worksheet in the correct area either under stripe (Credit Card), Paypal, or Charge account. From there I can do any of the other formulas to finish the sheet.

PAGE TWO

Order ID	Subtotal (inc tax)	Subtotal (ex tax)	Tax Total	Shipping Cost (inc tax)	Shipping Cost (ex tax)	Coupon Details	Refund Amount	Customer Name	Payment Method	Store Credit Redeemed
256​	206.8​	196.95​	9.85​	0​	0​		0​	Shannon Kirtzinger	Credit Card	0​
257​	84.32​	80.31​	4.01​	0​	0​		0​	Deryl Gallatin	Credit Card	0​
258​	119.25​	113.55​	5.7​	0​	0​		0​	Shaun Heglin	Credit Card	0​
259​	617​	587.62​	29.38​	0​	0​		0​	Paul Glandon	storecredit	617​
55555​	5555​	55​	55​	0​	0​		0​	test	PayPal	617​

Here is an example of what I am trying to accomplish, can anyone tell me what to do? I feel like it should be so simple, but I think because its in the same column I can't wrap my head around how to get the right thing to go where I want it. Is this possible?

Order ID	NS Document Number	Subtotal (inc tax)	Subtotal (ex tax)	Tax Total	Shipping Cost (inc tax)	Shipping Cost (ex tax)	Coupon Details	Refund Amount	Customer Name	Payment Method	Store Credit Redeemed
Stripe
256
257
258
Paypal
55555
Charge account
259

 

[GraH]

I can recommend a Power Query solution (which sounds awful and complicated, but the opposite is true). You have MSO 365, so probably You have Get & Transform on your ribbon?
You can load via a mouse click both tables to PQ and append the data. Where column headers match, the data ends up in the same column. Then you can group by Payment method, order ID, customer name and coupon details, and aggregate your totals using the SUM/COUNT.