How to cegrigate a data from a cell in the below cell with all the data listed

[Sai Prasad]

Hi,

I have a data as given below:
MachineApplicationInstall DateSystem NameName
CD2-AGMicrosoft Office Professional 2003 Microsoft Office Visio Viewer 200720130906CompRavi
NSI-DETRSMicrosoft Office Professional Plus 2007 Microsoft Project 200720130605NetwareKishore
There are two rows with the machine name and multiple applications listed in one cell in column B.

Is there a way I can segregate the data in such a way where in the product can be listed in the next cell and simultaneously get the machine, Install Date, System Name and Name listed with the second install?

Regards,
Sai.

 

[Somendra Misra]

Hi Sai,

Upload the same in a excel file.

Regards,

 

[Sai Prasad]

Sorry about that.....here is the file

 

[Somendra Misra]

@Sai Prasad

You have not mentioned how you want your data output should look like. For the sample uploaded kindly upload the output also.

Regards,

 

[Sai Prasad]

@Somendra Misra Attached is the data. where in the first table is what my data looks like, column B has multiple applications listed one below another which was the output from our tool.

The second table is the output where in single computer has the application listed in separate rows.

Is it possible....Indecently the tool where the data was derived was a Microsoft tool!!

 

[Somendra Misra]

@Sai Prasad

Wll there be duplicates of machine in your data?

Regards,

 

[Sai Prasad]

No....the Machine column has no duplicates

 

[Somendra Misra]

See the file.

Green Cells are helper cells Orange cells have solution.

Regards,