how to make a table to row column

[nader]

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

 

[Bill Ridgeway]

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

Nader,
Use <Paste Special><Transpose> to copy transposed data.

Bill Ridgeway
Computer Solutions

 

[nader]

Thanks Bill
but I want to keep the links

Nader,
Use <Paste Special><Transpose> to copy transposed data.

Bill Ridgeway
Computer Solutions

 

[nader]

Thanks Bill
but I want to keep the links between two tables

 

[vezerid]

Let us say that the number of columns with dates is 3. In the
subsequent formula you change the 3 to suit.
You will need an auxiliary column right before the data that you want
to produce. It must have the numbers 0, 1, etc. starting in A2 of the
target sheet.

In Sheet2!B2:
=INDEX(Sheet1!$A$2:$A$100,INT(A2/3)+1)

In Sheet2!C2 (here the number 3 is reflected in the number of columns
of B11):
=INDEX(Sheet1!$B$2:$D$2,MOD(A2,3)+1)

In Sheet2!D2:
=VLOOKUP(B2,Sheet1!$A$2:$D$100,MATCH(C2,Sheet1!$B$1:$D$1,0),FALSE)

Copy formulas Sheet2!B22 down.

HTH
Kostis Vezerides

 

[Bill Ridgeway]

Sorry, now I look at it again a Pivot Table will do that. Go to
<Data><Pivot Table ...> and follow the prompts. Pivot tables can be a bit
tricky at first but perseverance pays.

Regards.

Bill Ridgeway
Computer Solutions

 

[nader]

Thanks a lot Kostis, I have done what ever you said but it is not

 

[vezerid]

Nader,

In what way is it not working?

If you don't find a solution you can email me to: vezerid at act dot
edu. I will be going soon but I will reply tomorrow.

Regards,
Kostis