MikeTa
asked on
Excel table pivoting
I have an excel sheet with ~500 groups that look like:
x name
xxxx address
x city, state, country
x phone#
y name
yyyy address
y city
y phone#
it is there a quick way to make it look like this?
xname xxxxxaddress xcity xphone#
yname yyyyyaddress ycity yphone#
wname.......
x name
xxxx address
x city, state, country
x phone#
y name
yyyy address
y city
y phone#
it is there a quick way to make it look like this?
xname xxxxxaddress xcity xphone#
yname yyyyyaddress ycity yphone#
wname.......
Can we assume all your groups have four rows, separated by an empty row?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
sorry but I am a newbe were. how should I run the scripts ?
goto visual basic editor (Alt + F11)
Insert \ Module
copy code
go back to your workbook
run macro (Alt + f8)
pick macro and run
Voilà
T
Insert \ Module
copy code
go back to your workbook
run macro (Alt + f8)
pick macro and run
Voilà
T
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Open your file and follow the steps below:
1. Press Alt-F11 (VBA will open)
2. From Menu -> Insert -> Module
3. Past the code
4. Close the VBA and go back to Excel worksheet
5. Press Alt-F8 and select the macro (in this case if you paste my macro then it will display Tranp)
and hit run......
There you go
1. Press Alt-F11 (VBA will open)
2. From Menu -> Insert -> Module
3. Past the code
4. Close the VBA and go back to Excel worksheet
5. Press Alt-F8 and select the macro (in this case if you paste my macro then it will display Tranp)
and hit run......
There you go