Hi friends, Thanks for viewing my message. I have a table of product wise doctors mapping. Here product in header row and doctor in left column. I like to get product wise doctor list serially using excel formula from product wise doctors mapping data. I attached a file for understanding. Can any one help me by giving formula solution? Thanks Regards. Rashidulhttp://www.excelforum.com/excel-new-...ml#post3934177