Split of columns and rows based on delimiter

[umarabdulsattar3275]

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 

[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

[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. 

[ShankerV]

Hi @umarabdulsattar3275 

Please check whether you are expecting something like this.

Worked based on the your previous screenshot as an output.

[umarabdulsattar3275]

@ShankerV Thank you. But I want to split chargingnetwork, price and priceType also. 

[binuacs]

@umarabdulsattar3275 Looking for something like this