Load only selected rows from Excel and transpose the rows

[qlikwiz123]

I have an excel where the data shown below starts at Row 10. I need to load data from Row 10 to Row 12 only to load only three rows shown below and transpose the table to make Months as columns and only get Total row as values. Also remove the last column (Avg) from the final table.

Original Table:

	22-Jan	22-Feb	22-Mar	22-Apr	22-May	22-Jun	22-Jul	22-Aug	22-Sep	22-Oct	Avg
Cat A	0.33413	0.299457	0.275348	0.283128	0.349487	0.253043	0.257076	0.262531	0.263539	0.255453
Cat B	0.176894	0.165962	0.156509	0.159405	0.20852	0.128754	0.132616	0.138348	0.132312	0.133117
Total	0.511025	0.465419	0.431857	0.442533	0.558008	0.381798	0.389692	0.400879	0.395851	0.388571

Expected Output:

Month	Total
22-Jan	0.511
22-Feb	0.465
22-Mar	0.431
22-Apr	0.442
22-May	0.558
22-Jun	0.381
22-Jul	0.389
22-Aug	0.4
22-Sep	0.395
22-Oct	0.388

[MatheusC]

Hi, @qlikwiz123  I believe this post will help you.

https://community.qlik.com/t5/Brasil/Transposi%C3%A7%C3%A3o-Invers%C3%A3o-de-colunas-para-linhas-CrossTable-Table/td-p/1480026   

[anat]

Use named areas

If you only want to read a part of a sheet, you can select an area of columns and rows and define it as a named area in Microsoft Excel. Qlik Sense can load data from named areas, as well as from sheets.

Typically, you can define the raw data as a named area, and keep all extra commentary and legends outside the named area. This will make it easier to load the data into Qlik Sense.

or 

load * from excel

WHERE RecNo() > =10 AND RecNo() <= 12;