Move Excel Informtion to Columns Side by Side by Patient

[bpxmas]

I have a report I exported from Crystal v10 into Excel.

There are two columns A and B in Excel with ongoing data. I need to separate the data by Patient and place them in the next two columns C and D, etc. As you can see below the column names are 'Patient' and 'Patient Detail'

Col A Col B
Patient Patient Detail
John Smith Address

Col C Col D
Patient Patient Detail
Tom Jones Address

etc.....

I need the information to be side by side. Hopefully this makes sense. I tried creating Pivot Table, but it doesn't work and it rearranges the data into ascending alpa. Hopefully, someone can help me.

Thanks in advance.

 

[SkipVought]

Amen lameid!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[lameid]

I was thinking on the file menu you might have something like Export and Export Data... Each of those allowing you to select the file format. Like I said I've only barely used CR so I might just have wishful thinking.

So short of going with VBA like Skip said, you can use xlhelp's trick which is somewhat manual, or look at having the data dumped another by the appropriate IT people.

I am assuming CR is attached to some server database product and not something like an Access file you can get to... If it is Access you could probably directly get the data out of it. On the otherhand why anyone would use CR over Access's Report designer defies all reason. If you have a reason to use CR, Access files don't fit the bill.

 

[SkipVought]

It can be done without VBA if the results are in a proper data table.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[lameid]

To clarify, I am speaking to getting the data in a table format as a first step.

 

[bpxmas]

I exported to Access 2007

 

[SkipVought]

I exported to Access 2007

What does that mean? It is meaningless statement without explaining exactly what was exported, from where and how.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[lameid]

I was speaking to if the data as the source of the report started in Access but can you post the Table name, field names (hopefully there is one for each of the fields you want in which case we only need those).

The big question is did it layout the data like you have already posted or did it put it into columns like a table (crossing fingers).