convert text into columns

A

aquaflow

USER = ADMINISTRATOR
MAXPW = 1 MINPW = 1
NEWPASSWORDLIST =
PASSWORD = ?ÅÎßÐÞÆÌÌÈÕÌÅ
PU
SYSTEMUSER
COMSCONTROL
CANDECONTROL
CANDEGETMSG
PWMIGRATION = 1

like

User MAXPW MINPW NEWPASSLIST
Administrator
 
K

Kevin B

For the sake of example assume that the data resides in columns A and B

Select the data in column A and press <Ctrl> + C to copy the data

Right click on cell C1 and select PASTE SPECIAL from the short cut menu,
click the TRANSPOSE check box and then click the OK command button to exit
the dialog box

Select the data in column B and press <Ctrl> + C to copy the data

Right click on cell C2 and select PASTE SPECIAL from the short cut menu,
click the TRANSPOSE check box and then click the OK command button to exit
the dialog box

You can now delete the data in the original columns.
 
A

aquaflow

For the sake of example assume that the data resides in columns A and B

Select the data in column A and press <Ctrl> + C to copy the data

Right click on cell C1 and select PASTE SPECIAL from the short cut menu,
click the TRANSPOSE check box and then click the OK command button to exit
the dialog box

Select the data in column B and press <Ctrl> + C to copy the data

Right click on cell C2 and select PASTE SPECIAL from the short cut menu,
click the TRANSPOSE check box and then click the OK command button to exit
the dialog box

You can now delete the data in the original columns.

can a macro help?
 
Top