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 | ...
If for any Excel here
in G2
=IFERROR( INDEX( $B:$B, AGGREGATE(15,6,1/($A:$A=G$1)*( ROW($A:$A) - ROW($A$1) +1 ), ROW()-ROW($G$1) ) ), "")and drag it to the right and down till cells with empty text appear. The only it's much better to take some range instead of entire columns (or table or dynamic range).