(Solved) – Need to consolidate cells in range to one row

  • by

I have three runs of each specific name (Column C). How do I consolidate the three runs and move the matching Symbol (Column E), RT (Column G), and AO (Column H) for each run into the appropriate cell going left to right in one row (See example pic).

enter image description here

Leave a Reply

Your email address will not be published. Required fields are marked *