Organizing data into columns

[fajardok]

Ok, so this is probably and easy one, but I cant figure it out... I have a spreadsheet that was given to me, most of the information is aligned in the columns correctly, but there is some information not aligned correctly, let me try and explain.

Reports need to be filed, but not required, and missing dates are not aligned correctly...

Header --Col 1 -- Col 2 -- Col 3 -- Col 4
Person 1 --Rep03--Rep05--Rep06
Person 2 --Rep03--Rep04--Rep05--Rep06
Person 3 --Rep04--Rep05--Rep06

So instead of having all the people who filed Rep03 in Col1 and everyone who filed Rep04 in Col2, the information isnt aligned. I want Col 1 to only be Rep03, Col 2 only to be Rep04, etc... and if they didnt file Rep04, Col2 would be empty... I hope I am making sense
can I sort that???

[mrice]

Please see the attachment. I've used the following macro to create a copy in adjacent columns with the values correctly aligned. Hit the GO button.

Please Login or Register  to view this content.