How to convert a table into range form in Excel?

Occasional Visitor

IMG-20220820-WA0000.jpg

Please suggest me formula 

1 Reply

@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.