Hi Guys,
Do you know how to (Loom | Send a video. Not a thousand words.)
Fill the First Field with data from same row in another column (eg B and then fill second row etc with data in the same row from another column (eg D) all the way until sequence changes in the reference column (C)
Do you know a quick VBA or Macro , Query or formula to do this?
See minisheet of a simplified version
So:
Based on checking sequence of repeated values in Column C (ParentID)
Column A will need to return the values of cells referenced in the example.
So basically The first value in Row A2 should be that in B2 and the next (A3) should be from D3 and so on until it gets to the next sequence in column C (ParentID) where it changes to AKS112 A7 will be the value of B7 = 'Insane Man' where the next row (A8) will be that of D8 =Insane Man Pan and so forth
Hopefully you can assist soon. Thank you
Best regards Devereaux
Do you know how to (Loom | Send a video. Not a thousand words.)
Fill the First Field with data from same row in another column (eg B and then fill second row etc with data in the same row from another column (eg D) all the way until sequence changes in the reference column (C)
Do you know a quick VBA or Macro , Query or formula to do this?
See minisheet of a simplified version
So:
Based on checking sequence of repeated values in Column C (ParentID)
Column A will need to return the values of cells referenced in the example.
So basically The first value in Row A2 should be that in B2 and the next (A3) should be from D3 and so on until it gets to the next sequence in column C (ParentID) where it changes to AKS112 A7 will be the value of B7 = 'Insane Man' where the next row (A8) will be that of D8 =Insane Man Pan and so forth
Hopefully you can assist soon. Thank you
| FillDataSheet.xlsx | ||||||
|---|---|---|---|---|---|---|
| A | B | C | D | |||
| 1 | Title | Parent Name | Parent ID | Variant Name | ||
| 2 | = B2 | Mr Perfect | ABC1 | Mr Perfect Show | ||
| 3 | = D3 | Mr Perfect | ABC1 | Mr Perfect Hat | ||
| 4 | = D4 | Mr Perfect | ABC1 | Mr Perfect Cat | ||
| 5 | = D5 | Mr Perfect | ABC1 | Mr Perfect Bat | ||
| 6 | = D6 | Mr Perfect | ABC1 | Mr Perfect Rat | ||
| 7 | = B7 | Insane Man | AKS112 | Insane Man Van | ||
| 8 | = D8 | Insane Man | AKS112 | Insane Man Pan | ||
| 9 | = D9 | Insane Man | AKS112 | Insane Man Bones | ||
| 10 | = D10 | Insane Man | AKS112 | Insane Man Homes | ||
| 11 | = B11 | Super Man | SPMM | Super Man Costume | ||
| 12 | = D12 | Super Man | SPMM | Super Man Hoodies | ||
| 13 | = D13 | Super Man | SPMM | Super Man Booties | ||
| 14 | = D14 | Super Man | SPMM | Super Man Car | ||
| 15 | = D15 | Super Man | SPMM | Super Man Bikes | ||
| 16 | = B16 | Bombastic | BM | Bombastic Tastic | ||
| 17 | = D17 | Bombastic | BM | Bombastic Plastic | ||
| 18 | = D18 | Bombastic | BM | Bombastic Paper | ||
| 19 | = B19 | Rough Neck | RN | Rough Neck Food | ||
FillDataSheet | ||||||
Best regards Devereaux
