Hi, Hope someone can assist with this query.
I have an excel sheet with 2 Columns. sample below
What I'm trying to do is, for each value in Column 1, I need to create 4 rows as per column 2.
Expected
Is there a formula I can use to do this?
Thanks
I have an excel sheet with 2 Columns. sample below
Name | Product |
Paul | Apple |
Sara | Orange |
Adam | Berry |
Peach |
What I'm trying to do is, for each value in Column 1, I need to create 4 rows as per column 2.
Expected
Paul | Apple |
Paul | Orange |
Paul | Berry |
Paul | Peach |
Is there a formula I can use to do this?
Thanks