Forum Discussion
Change data structure
Hello, I will try to be clear sorry if am not Have I data that is structure like such: COLUMN A B 1:phone | customer info 2: email | custumer info 3: phone | ...
A formula solution. Please see attached workbook.
- to use SEQUENCE function for row number in INDEX function looks good 🙂
Because my colleagues don't have O365, i am trying to create solutions to let them use my solutions. There are many different approaches for dynamic arrays. Thanks for sharing that kind of usage ✌
