Forum Discussion

Jilly's avatar
Jilly
Copper Contributor
May 07, 2019
Solved

Combine data from multiple rows into a single row

Hi Excel community   I have a dataset that looks something like this   Incident #             Name of person reporting           Role of person reporting             Location of Incident   123  ...
excel
JKPieterse's avatar
JKPieterse
Silver Contributor
May 07, 2019
If you don't really need the information from those three columns which are causing the repeat of rows, you could just use Data, Remove Duplicates and exclude those three columns. Note that Excel will keep the FIRST row of every duplicate, so you may want to consider sorting the data prior to removing duplicates so the rows you want to keep are at the top.
  • Jilly's avatar
    Jilly
    Copper Contributor
    May 07, 2019

    JKPieterse 

     

    Thanks for the reply.  Unfortunately I do need to keep all the info.  Sergei has given me the answer I need.  Hopefully helps others.

    Cheers

Resources