Is there a simple way (without macro/vba) to move data on multiple rows for a common field to a single row, using multiple columns, For example, see INPUT and OUTPUT below; columns b and c of the second row are moved to d and e (then f and g, etc.) of the first row if column a has the same value as the previous row. ie multiple lines per agent are converted to a single line per agent.
eg
INPUT
a1 b1 c1
a2 b2 c2
a3 b3 c3
a3 b4 c4
a3 b5 c5
a6 b6 c6
a7 b7 c7
a7 b8 c8
a9 b9 c9
a10 b10 c10
OUTPUT
a1 b1 c1
a2 b2 c2
a3 b3 c3 b4 c4 b5 c5
a6 b6 c6
a7 b7 c7 b8 c8
a9 b9 c9
a10 b10 c10