Home | Blog | Software | Reviews and Features | Forum | Help | Donate | About us
topbanner_forum
  *

avatar image

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

Login with username, password and session length
  • December 07, 2016, 02:38:32 AM
  • Proudly celebrating 10 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 1150 times)

kalos

  • Member
  • Joined in 2006
  • **
  • default avatar
  • Posts: 1,473
    • View Profile
    • Donate to Member
cross tabulation
« on: September 22, 2011, 01:13:15 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: 4,664
    • View Profile
    • Donate to Member
Re: cross tabulation
« Reply #1 on: September 22, 2011, 05:06:25 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,473
    • View Profile
    • Donate to Member
Re: cross tabulation
« Reply #2 on: September 23, 2011, 11:12:50 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,367
    • View Profile
    • Donate to Member
Re: cross tabulation
« Reply #3 on: September 23, 2011, 01:48:55 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  :)