I have a very large spreadsheet with columns A-M. Each row has an ID number (A), a description (B) and three columns relating to action (Type of Action (C), Action itself (D), Who authorised (E), Authorised Date (F) and Completion Date(G)).
What I want to do is have a formula or method to automatically join together the text in Columns C-G and place that text in Column H, BUT only where the Id number in Column A is the same. Please see example below. The number of rows varies for each ID. I don't actually need Columns C-G in the final output if that makes it easier but they can be left in if too complex. Hope this makes sense!
Example
001 Broken Furniture Repair Furniture sent for fixing TBrookes 1 October 2015 5 October 2015
001 Broken Furniture Replace Furniture unable to be repaired. Replacement ordered Tbrookes 6 October 10 October 2015
002 Low Beam Replace Contractor called to replace beam JSwift 30 September
002 Low Beam Replace Contractor advised waiting on parts. T Brookes 5 October 2015
Results
A B C D E F G H
001 Broken Furniture Repair Furniture sent for fixing TBrookes 1 October 2015 5 October 2015 Repair Furniture sent for fixing TBrookes 1 October 2015 5 October 2015 Furniture unable
to be repaired. Replacement ordered Tbrookes 6 October 10 October 2015
001 Broken Furniture Replace Furniture unable to be repaired. Replacement ordered Tbrookes 6 October 10 October 2015
002 Low Beam Replace Contractor called to replace beam JSwift 30 September Replace Contractor called to replace beam JSwift 30 September Replace Contractor advised
waiting on parts. T Brookes 5 October 2015
002 Low Beam Replace Contractor advised waiting on parts. T Brookes 5 October 2015
Thanks in advance.
Bookmarks