Can someone help me with this? I have 9300 rows of data when I should have
around 480. It is impossible to read the current table.
Thank you.

"Vic" wrote:

Each occurence of A has 20-30 rows of data appearing in columns B thru K. I
need to collapse all rows into one per each occurence of A. Value in A
appears only once. For example:
A2 = 035
B2 = abc
c3 = def
e4 = ghi
k5 = jkl
d6 = mno
c7 = pqr
b8 = stu
I need to see 1 row:
A B C D E F G H I J
K
035 -abc -def -mno -ghi -jkl
-stu -pqr

How can I accomplish this?