Google sheet Formula to get an Result from input

I have this sheet looking to create a formula that gives the output as mentioned in sheet.

https://docs.google.com/spreadsheets/d/1kIN8PX-eWzZZdkKA7l2GyqoPPecWZGGPOu6jWjhRJTk/edit?usp=sharing

1 answer

  • answered 2020-07-29 17:41 player0

    use:

    =ARRAYFORMULA(
     TRANSPOSE(SPLIT(REPT(CONCATENATE(A2:A&CHAR(9)), COUNTA(B2:B)), CHAR(9)))&" - "&
     TRANSPOSE(SPLIT(CONCATENATE(REPT(B2:B&CHAR(9), COUNTA(A2:A))), CHAR(9))))
    

    enter image description here