Covert column to first row

Can i convert the column headers to first row?

You can use the “Table metadata” action + “Pivot” to create a 1-row table with column names. Then “Append”. See below:

de-label.morph (3.0 KB)

Thanks @dgudkov for this.

If we dont have sample data table then how to achieve it without using append and merge?

I had different cells with different information segregated in first 5 rows in excel workbook.

I was able to achieve transformation where I have all the relevant information coming as column headers and now want to have the header information copied over to first row. Is that possible?

I’m not sure I understand your question. Can you elaborate?

Final initial

I have column header only ( no data in first row) and i want to populate first row same as column headers as shown in final output image.

Look at the example I posted above. It does exactly that except on the last step it appends the main table which you can ignore.