I want to transpose the coumns to rows and rows to colums ....can anyone please help me ?

[chandrika_sada]

X	1	2	3
B	a	d	i
C	b	e	h
D	c	f	g

I want the above table to converted as below

X	B	C	D
1	a	d	i
2	b	e	h
3	c	f	g

[Qiu]

@chandrika_sada 
It is now easy as it looks like to me ...🤣

[Qiu · Accepted solution]

@chandrika_sada 
I was thinking too much...

The basic rule is not to touch the data as much as possible so it leaves us with Dynamic Rename tool. 😂

[chandrika_sada]

Thank you