Hello StrobelJones,
Are you looking for something like this?

if yes, then you would have to sort the columns by COLUMN and then do a fill down on Column(1). if this is not what you are looking for, could you please elaborate on your example?
Thank You,
Akshay