[image] I have table like this. I have level in column 1. I want to make columns for the different levels. Also I want to format rest of the data accordingly like the following image. [image] I used pivot node but because of the levels are not consistent Itdidn’t work properly. May be I need to use lagging function (Which I don’t know how to use) to identify different parent and sub section every time I pivot the level column. Can somebody please help me with this?

Hi @Tushar_07 , Here you are: [Untitled] formatting.knwf (75.9 KB) :blush:

Formatting of data

ScottF July 3, 2019, 9:27pm 2

I just tried it out, and you can get there with something very similar to this workflow from another thread:

If you need more specifics, let me know.