topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Friday March 29, 2024, 1:02 am
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: cross tabulation  (Read 2674 times)

kalos

  • Member
  • Joined in 2006
  • **
  • default avatar
  • Posts: 1,823
    • View Profile
    • Donate to Member
cross tabulation
« on: September 22, 2011, 01:13 PM »
hello

I have in an excel file a table like this and I want to make it look like the table below:
del.jpg

anyone know how to do it?

thanks!

skwire

  • Global Moderator
  • Joined in 2005
  • *****
  • Posts: 5,286
    • View Profile
    • Donate to Member
Re: cross tabulation
« Reply #1 on: September 22, 2011, 05:06 PM »
I'm no Excel wizard, but I'm pretty sure you can do what you want with a pivot table.

kalos

  • Member
  • Joined in 2006
  • **
  • default avatar
  • Posts: 1,823
    • View Profile
    • Donate to Member
Re: cross tabulation
« Reply #2 on: September 23, 2011, 11:12 AM »
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

  • Friend of the Site
  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 4,776
    • View Profile
    • Donate to Member
Re: cross tabulation
« Reply #3 on: September 23, 2011, 01:48 PM »
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  :)