Hi,
I have Car Names on multiple rows 200k (Column A). For every Car name I have multiple entries containing 'parts' added by an extra row.
Column AColumn B
Audi3 Seats
Audi3 Tyres
Audi3 **
Audi3 Seats
BMW325 Radio
BMW325 Steering Wheel
BMW325 Seats
GolfTyres
I want every unique entry in Column A to have all its associated 'parts aligned against it in one row. Please see example:
Column A Column B Column C Column D Column E
Audi Seats Tyres ** Seats
BMW325 Radio Steering W Seats
Golf Tyres
Can someone please help?
Bookmarks