Eladnoam2

Mar 15, 2022Copper Contributor

# 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 | dog | cat | fish |

123 | ab | cd | |

456 | jh | ef |

there is any formula?

TY

Eladnoam2

Mar 15, 2022Copper Contributor

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 | dog | cat | fish |

123 | ab | cd | |

456 | jh | ef |

there is any formula?

TY

- PeterBartholomew1Silver Contributor
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?

- Eladnoam2Copper Contributorty 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!- Riny_van_EekelenPlatinum Contributor
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.

- Riny_van_EekelenPlatinum Contributor
- NikolinoDEGold Contributor
The proposed solution with PQ is actually the most elegant, but here is an additional solution with VBA if you are not familiar with PQ.

I know I don't know anything (Socrates)