How to convert a table into range form in Excel?

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.