Help transforming the input table

[mrthomasshelby]

Hello all!

I have a table as shown below in an excel file:

No	R1	Units	Price
			150m	300m	600m	900m	1500m	2500m
1	½	LS	5	10	15	20	25	30
2	¼	LS	10	15	20	25	30	35
3	¾	LS	15	20	25	30	35	40

I need to transform the above table into the table as shown below:

Name	S1	S2	S3	Units	Price
//This field should have the excel filename in all the rows//	//This field should have the excel file tab name in all the rows//	½	150m	LS	5
		½	300m	LS	10
		½	600m	LS	15
		½	900m	LS	20
		½	1500m	LS	25
		½	2500m	LS	30
		¼	150m	LS	10
		¼	300m	LS	15
		¼	600m	LS	20
		¼	900m	LS	25
		¼	1500m	LS	30
		¼	2500m	LS	35
		¾	150m	LS	15
		¾	300m	LS	20
		¾	600m	LS	25
		¾	900m	LS	30
		¾	1500m	LS	35
		¾	2500m	LS	40

Although I have been using Qlik View for sometime now, I have came across a table transformation with merged labels and converting column to rows scenario. Please help me out with this! TIA! stalwar1‌

[sunny_talwar]

I think you need this

The Crosstable Load