Share via

Formula to combine text from multiple rows of text into a single cell, without duplicating text from previous rows

Anonymous
2024-10-28T01:42:13+00:00

I have a list of data with long text that excel split into separate rows. I want a formula to combine each text to a single cell without duplicating the previous cell data above. Would really appreciate the help. Example shown in the table below :-

Data Result
Apple Apple Orange Lemon 123
Orange
Lemon
123
Orange Orange Orange Lemon
Orange
Lemon
Apple Apple Apple Apple 1 2
Apple
Apple
1
2
Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

10 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-10-28T23:57:29+00:00

    [ Edited:] It only works for 365, not 2019. Sorry.

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2024-10-29T00:03:05+00:00

    Sorry,this is an online sql tool https://e.anyoupin.cn/EData/?s=1368 instead of Excel formular.

    You need to upload your data to the database and run the sql statement.

    0 comments
  3. Anonymous
    2024-10-29T00:18:43+00:00

    Hi what formula is this, I'm currently running on Excel 2019.

    0 comments
  4. Anonymous
    2024-10-29T00:23:05+00:00

    This site is blocked for me, are there any alternative sites you can provide. That would be great !

    0 comments
  5. Anonymous
    2024-10-29T23:18:31+00:00

    No other alternative site available.

    Can you try visit the site by android smartphone?

    0 comments