Is there same option to uupivort columns as we do in Power Query
Do you mean unpivot for a pivot table?
