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

[Emil_Kos]

Hi @JDong,

Please find attached.

Just to confirm how the calculations I have performed:

Cost= [Cost A]+[Cost B]+[Cost C]

Cost 2= [Cost A2]+[Cost B2]+[Cost C2]

[JDong]

Thanks for the quick reply ! @Emil_Kos 

Sorry my question was not clear..I actually do not want to add but just display as individual line items

[Emil_Kos]

Hi @JDong,

Could you provide how the first line should look like in the output file?

I am not exactly sure what is the desired output. 

[atcodedog05]

Hi @JDong 

Can you provide output so that we can work on achieving it.🙂

[AngelosPachis]

Hi @JDong 

Does your desired output look something like this maybe, where everything is displayed in a single line?

[JDong]

Thanks to all of you !

Just made the question more clear.

Hope it helps.

[Emil_Kos]

Hi @JDong,

I think I got a solution for you if you need something like @AngelosPachis showed:

[atcodedog05 · Accepted solution]

Hi @JDong 

Here is a workflow with the expected output:

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[AngelosPachis]

Hi @JDong ,

Do you mind if you check this works for you? You should update the filter as you said, and maybe later you can convert it into an app which will automate things somehow