Updating data with Column names

[Niru]

Hello All,

kindly help me to get below mentioned output.

INput:

ID	CCB_MARKETING_AND_COMM	CCB_OPERATIONS	US_PB	US_WM	WM__Detail_Deck_Only_
115563		115563	115563
115564		115564		115564	115564

Expected Output:

ID	CCB_MARKETING_AND_COMM	CCB_OPERATIONS	US_PB	US_WM	US_WM
115563		CCB_OPERATIONS	US_PB
115564		CCB_OPERATIONS		US_WM	US_WM

Thanks & Regards,

Niru

[Emil_Kos · Accepted solution]

Hi @Niru,

In the last column, you need to rename yourself as I didn't saw any pattern to it. The solution is replicating the column name if the position isn't empty. 

I think this solution should be sufficient for you.

The output:

[AngelosPachis · Accepted solution]

Hi @Niru ,

Maybe this would work?