hi all bro
i want all you help me to creat macro for bellow my file ( with : A, B , 1-4: is columns and rows in excel, --- is no thing )
from :
-------A---------B
1 ----aaa----- egr
2 ----e-egr ---bcd
3 ----abcd ----aad
4-- ---aad -----aaa
to :
------A-------- B
1 ----aaa---- aaa
2 ----e-egr ----egr
3 ----abcd ----bcd
4 -----aad -----aad
i want have a macro to arrangement file like above. please help me
thank all you to read my thread
best regards!