Main Area and Open Discussion > General Software Discussion
cross tabulation
(1/1)
kalos:
hello
I have in an excel file a table like this and I want to make it look like the table below:
anyone know how to do it?
thanks!
skwire:
I'm no Excel wizard, but I'm pretty sure you can do what you want with a pivot table.
kalos:
I'm no Excel wizard, but I'm pretty sure you can do what you want with a pivot table.
-skwire (September 22, 2011, 05:06 PM)
--- End quote ---
yup, I am too sure it can be done easily, but I know nothing about pivot tables and their terminology
if not in excel, is there any other program that can do it? or maybe a good text editor with replace function or script?
cranioscopical:
yup, I am too sure it can be done easily, but I know nothing about pivot tables and their terminology
-kalos (September 23, 2011, 11:12 AM)
--- End quote ---
I'm no Excel expert either but it does have good built-in help. You probably could learn from that what to do.
Hope that helps :)
Navigation
[0] Message Index
Go to full version