Consider the following data in Excel
AutoCAD VB VC++ .NET
PC01 Yes Yes
PC02 Yes
PC03 Yes Yes
I want to re-arrange the data in the following format.
PC number Software1 Software2 re 3
PC01 AutoCAD VC++
PC02 VB
PC03 AutoCAD .NET
Thank you in advance.[/img]
AutoCAD VB VC++ .NET
PC01 Yes Yes
PC02 Yes
PC03 Yes Yes
I want to re-arrange the data in the following format.
PC number Software1 Software2 re 3
PC01 AutoCAD VC++
PC02 VB
PC03 AutoCAD .NET
Thank you in advance.[/img]