How to convert a table into range form in Excel?

[abdul-gafformd]

Please suggest me formula 

[#2]

@abdul-gafformd I suspect that your real data set is a bit more extensive than your example and suggest you look into Unpivot via Power Query, as demonstrated in the attached file.