How to Align Cell based on Content

[svanan]

Good Evening,

I have a set of data in Excel 2010, as the below sample. The data has a variable length of row and each row have variable column size.

Please Login or Register  to view this content.

I am trying to sort each row, if the cell of the selected row have the same cell content as the cell in the first row then it should be aligned vertically in a column. Else it should be shifted to the right and same comparison will be done as previous. The first row would always be the reference row as it has all the combination of data for a particular set.

The expected result for the sample data above is as below.

Please Login or Register  to view this content.

Currently I am doing this manually by hand, is there anyway to automate this by a script ? Have more than 100 set of data to align.

Can you assist to give me pointers or lead me where I can do further reading on this? My search have not been fruitful so far. Thank you very much

[rylo]

Hi

try this

Please Login or Register  to view this content.

rylo

[svanan]

Worked like a charm! Thanks rylo!