Split of columns and rows based on delimiter

Hi everyone.

I want to split this data but one evseId have one (PowerType, price, priceType)
but some evseid have two type of (PowerType, price, priceType). I want to split data based on PowerType.

Thank you

Capture.PNG

Workflow

Help

Preparation

Accepted answers

All comments

ShankerV

Hi @umarabdulsattar3275

Can you please paste the data in excel sheet.

Or copy and paste format.

So can be used for Input.

umarabdulsattar3275

Here is the excel file

Sample_Data.xlsx

ShankerV

Hi @umarabdulsattar3275

Also wanted to understand the data, can you explain how the output needs to be.

24253-1 has DC,AC

but the next line 3213-1,3213-1 has AC, AC

How it needs to be split please.

umarabdulsattar3275

Dear @ShankerV .

some ID have two type on PowerType some have only one.

binu_acs

@umarabdulsattar3275 Looking for something like this

Split_080223_1.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703