Need help in aligning data in different rows

[Pasi12]

Hi all,

Need help in aligning my excel sheet. data is scatted all over row and I need a way to align each row with corresponding adjacent rows in each column.

The worksheet has about 6000 row and data scattered and each rows are not aligned. pls see attached.

Much appreciated!
Pasi


14056

[p45cal]

give us a small file with sensitive data altered (not removed) with say, find-and-replace, then we'll know what's going on.

[Pasi12]

how do I add attachment?

[Pasi12]

Can you copy /paste below to an xls file?


Appointment Status List
Date Ranges 7/1/2012 to 7/31/2015







Visit Date
Visit Column
Visit Status
Time
Patient


07/02/2012






Rick




NO ACTION





8:30AM
Test


07/03/2012






Rick




NO ACTION





8:30AM
Test2





9:30AM
Teszt2


07/06/2012






Rick




NO ACTION





8:30AM
Ron


07/18/2012






Rick




NO ACTION





8:30AM
John


07/20/2012






Rick




NO ACTION





8:30AM
SEAN





10:00AM
MATTHEW





11:00AM
MATTHEW


08/06/2012






Rick




NO ACTION





8:30AM
BARBARA





9:00AM
PEGGY


08/09/2012






Rick




NO ACTION





8:30AM
THOMAS


08/10/2012






Rick




NO ACTION





8:30AM
PEGGY


08/13/2012






Ricketts




NO ACTION





8:30AM
ROSALIE


08/14/2012






Rick




NO ACTION





2:30PM
CIERRA

[p45cal]

Reply, Go Advanced button, Manage Attachments button, Add files, Select Files, follow your nose.

[Pasi12]

Its attached. Thanks!

[p45cal]

See attached

[Pasi12]

Thanks! I appreciated this!
Pasi