cross tabulation

[kalos]

hello

I have in an excel file a table like this and I want to make it look like the table below:
[attach=#]

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.

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

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