Transpose and combine column data

[JDong]

Hi team,

I have the following data

Level 1	Level 2	Level 3	Cost Fruits	Cost Fruits 2	Cost Vegetables	Cost Vegetables2	Cost Dry	Cost Dry2	Asset
L1	Apple	Europe	100	150	58	3	21	39	Fruits
L2	Banana	Cost Rica	20	25	72	49	67	69	Fruits
L3	Orange	Spain	45	60	391	293	89	9	Fruits
L1	Brocolli	US	100	150	58	3	21	39	Vegetables
L2	Tomato	Italy	20	25	72	49	67	69	Vegetables
L3	Onion	France	45	60	391	293	89	9	Vegetables

I expect to transpose and combine the data values into 2 column

Level 1	Level 2	Level 3	Cost	Cost2	Asset
L1	Apple	Europe	100	150	Fruits
L2	Banana	Cost Rica	20	25	Fruits
L3	Orange	Spain	45	60	Fruits

How can I achieve the data in the above format. Later I just want to filter on the Asset column to view the data for each Asset.

Thanks

[atcodedog05]

Happy to help 🙂 @JDong 

Cheers and Happy Analyzing 😀