Hi Gurus,
Would need your kind expertise to help on this request.
Assuming I’ve the following sample data (SampleData1.xlsx) and wishing if the output data could be formatted using some kind of excel formulas/VBA coding.
For example:
Sheet1 (Sample Data)
It contains a simple matrix showing list of students and subjects that they've selected, marked with "X".
Sheet2 (Desired Output)
This is a sample output showing students and subjects that they've selected, without the mark "X" and any blank space in between.
The sample data could be long and massive, so it's best if the formula can be made flexible to cater for this.
Appeciate for any of your help and advice.
Thank you a lot in advance.
- Jack
Bookmarks