Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
Alexandraa.
 | Femeie
23 ani
Braila
cauta Barbat
26 - 80 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 795
|
|
Source:
I wanted to transpose a table with 18 columns and 5 rows into a table with 5 columns and 18 rows for a more compact view.
The original table exists in another sheet and is located in range C25:S30
The requirement for TRANSPOSE to work is to ensure the relationship between column and row numbers, so:
- 18 columns & 5 rows will become 5 columns & 18 rows.
See the relationship?
I want to move table DateDashboard!C25:S30 to the active sheet in range M29:R45.
The formula I used was =TRANSPOSE(IF(DateDashboard!C25:S30="";"";DateDashboard!C25:S30))
IMPORTANT! The way to enter this formula is:
1. Select destination cells - M29:R45 in my case
2. In the formula bar insert: =TRANSPOSE(IF(DateDashboard!C25:S30="";"";DateDashboard!C25:S30))
3. Press CTRL+SHIFT+ENTER to enter the formula in all cells of the selection
Modificat de TRaP (acum 5 ani)
|
|
| pus acum 5 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 795
|
|
This can also be done with HLOOKUP.
Assuming in range C2:G14 I have on horizontal data for 4 cities (row 2) and on vertical data for 12 months (column C), and I want to transpose this to a horizontal table, in range C16:O20.
The formula I would use in D17 would be:
=HLOOKUP($C17;$C$2:$G$14;2;FALSE)
Then drag this down for the 4 cities and right for the 12 months, changing row_index_num each time.
|
|
| pus acum 5 ani |
|