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:


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)

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)

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