Split the header into multiple rows

[AmolJadhav]

i have concatenated single row need to be split into three row header. can anyone please help on this. please note: i have multiple columns like this around 200 and above.

[flying008]

Hi, @AmolJadhav 

Maybe you can use Dynamic-Rename tool to change the all your want.

[AmolJadhav]

@flying008 thank you for your reply. If you see attached image one more time i want C,D,E text into different rows.

[flying008]

Hi, @AmolJadhav 

So, in your case, the A, B, C_D_E are the name of fields or first row of data ?

[Peachyco]

Some more clarifications:

1. Your sample dataset has three columns named "C_D_E" and once they're shifted, you will be left with three columns named "C". Is it normal for your dataset to have multiple columns with the exact same name?
2. The numbers between your starting sample data and your ending sample data changed, but I can't figure out their behavior. What is the logic/mathematics behind the change in the numbers?

[CoG]

If the data "headers" are also just rows of data, here is sample workflow that should meet your requirements: