Forum Discussion
merging rows
hi, i have a table like this: number dog cat fish 123 ab 123 cd 123 456 jh 456 ef and i want result look like this? number d...
I think Riny has the edge but, just to show it is possible, here is a 365 formula.
It all goes so well until you get the message that arrays of arrays are not supported. Why?
Why have two dimensions on the sheet at all if you are not allowed arrays of arrays; here one row for each distinct number?
ty all!!!
PeterBartholomew1
i cant copy ur formula.
Riny_van_Eekelen
there is any simple guide that i can lear how to do it by my self to my data?
ty again!
PeterBartholomew1
i cant copy ur formula.
Riny_van_Eekelen
there is any simple guide that i can lear how to do it by my self to my data?
ty again!
Eladnoam2 Power Query isn't simple, but it isn't all that difficult either. The link below is a good starting point, but you have to invest some time to learn it.
