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