Re: how to make a table to row column

Giganews Newsgroups
Subject: Re: how to make a table to row column
Posted by:  Jason Lepack (jlepa…@gmail.com)
Date: 22 Jan 2007

How to convert a pivot table to a data sheet... using a pivot table!!

This info will do exactly what you want.
http://j-walk.com/ss/excel/usertips/tip068.htm

Cheers,
Jason Lepack
nader wrote:
> Hi,
> I have a really big table with date as heading :
>
> People  11/07    12/07    13/07
> john        1          2          5
> wolf        5          4          7
>
> how can I make to be seen as:
>
> People    Date      Number
> john      11/07        1
> john      12/07        2
> john      13/07        5
> wolf        11/07        5
> wolf        12/07        4
> wolf        13/07        7
>
> the spreadsheet is to long so it is not possible to do it by copy and
> paste, I also want to keep the link
> anybody can help?
> I really appreciate that
> thanks
> Nader

Replies

In response to

how to make a table to row column posted by nader on 22 Jan 2007