How do I forward fill line items data in Google Sheets?

Question

I have an exported sheet of order line items and that has a master order number in column A but the order data is only completely filled on the first line item.

The blank cells are creating an issue when I try to work with the data.

What is the best way to fill out the blank cells with the data from the first line item?

I've tried to merge rows but I am only trying to merge if the cells are empty and of the same order number.

I came up with an idea:

1. =if($A3=$A2,if(ISBLANK(C2),"",C2),"FALSE")

2. Then filter by blank cells and copy and paste.

Is this the best way?

Input:

Name	Email	Shipping Method	Lineitem quantity	Lineitem price	Lineitem sku	Shipping Address1	Shipping Address2	Shipping City	Shipping Zip	Shipping Province
985292	email1@gmail.com	Expedited Plus Shipping (3-4 days)	1	0	XXXXSKU	XXXXXX Avenue	Apt #220	Venice	90291	CA
985292	email1@gmail.com		1	24.95	XXXXLO01
985292	email1@gmail.com		2	44.95	PRO20LL
985285	email2@gmail.com	Expedited Plus Shipping (3-4 days)	1	85.4	PRO20LL02	XXXXXX Ave		Norwell	2889	RI
985288	email3@gmail.com	Priority Shipping (2-3 days)	1	44.95	PRO20LL	XXXXXX Parkway		Minneapolis	55408	MA
985287	email4@gmail.com	Priority Shipping (2-3 days)	1	44.95	PRO20LL	XXX Street	Apt #4	Minneapolis	55102	MN
985250	email5@gmail.com	Expedited Plus Shipping (3-4 days)	1	35.96	XXXXX-01	XXXXX Road		Norwell	2061	MA
985250	email5@gmail.com		1	40.46	PRO20LL
985250	email5@gmail.com		1	35.96	XXXX_SK01

Ideal output:

Name	Email	Shipping Method	Lineitem quantity	Lineitem price	Lineitem sku	Shipping Address1	Shipping Address2	Shipping City	Shipping Zip	Shipping Province
985292	email1@gmail.com	Expedited Plus Shipping (3-4 days)	1	0	XXXXSKU	XXXXXX Avenue	Apt #220	Venice	90291	CA
985292	email1@gmail.com	Expedited Plus Shipping (3-4 days)	1	24.95	XXXXLO01	XXXXXX Avenue	Apt #220	Venice	90291	CA
985292	email1@gmail.com	Expedited Plus Shipping (3-4 days)	2	44.95	PRO20LL	XXXXXX Avenue	Apt #220	Venice	90291	CA
985285	email2@gmail.com	Expedited Plus Shipping (3-4 days)	1	85.4	PRO20LL02	XXXXXX Ave		Norwell	2889	RI
985288	email3@gmail.com	Priority Shipping (2-3 days)	1	44.95	PRO20LL	XXXXXX Parkway		Minneapolis	55408	MA
985287	email4@gmail.com	Priority Shipping (2-3 days)	1	44.95	PRO20LL	XXX Street	Apt #4	Minneapolis	55102	MN
985250	email5@gmail.com	Expedited Plus Shipping (3-4 days)	1	35.96	XXXXX-01	XXXXX Road		Norwell	2061	MA
985250	email5@gmail.com	Expedited Plus Shipping (3-4 days)	1	40.46	PRO20LL	XXXXX Road		Norwell	2061	MA
985250	email5@gmail.com	Expedited Plus Shipping (3-4 days)	1	35.96	XXXX_SK01	XXXXX Road		Norwell	2061	MA

Answer 1

• This is called forward fill and can be accomplished using SCAN. Using SCAN, iterate through each Name(col A) and to get a comparator function to compare each item(c) to the previous accumulated one(a)
• Extend each col A inside SCAN using OFFSET to the entire 10 columns(ce)
• Compare current Col A Name with the accumulator's Name and if current value is empty, put the accumulator, else the extended current value ce

Assuming the table is in A1:K10, in A15,

=SCAN(
  A1,A2:A10,
  LAMBDA(a,c,
    LET(
      cols,10,
      ce,OFFSET(c,0,0,1,cols),
      ARRAYFORMULA(
        IF(
          (ce="")*((c=INDEX(a,1,1))),a,ce
        )
      )
    )
  )
)