Excel 2010 - Traspose lowest row to upper row

M

mauriziosessa

New Member
Joined
Nov 27, 2012
Messages
13
Hi guys,
I am not able to solve this problem.
I would transpose value from rows with blank CASC. value to the upper row with a not blank CASC. value.
The number of row with blank CASC. value is variable.


i.e. :

<!--EndFragment-->​
[TABLE="width: 1235"]
<tbody>[TR]
[TD="width: 65, align: right"]Column= [/TD]
[TD="width: 65, align: right"]CASC.[/TD]
[TD="width: 65, align: right"]C[/TD]
[TD="width: 65, align: right"]D[/TD]
[TD="width: 65, align: right"]E[/TD]
[TD="width: 65, align: right"][/TD]
[TD="width: 65, align: right"][/TD]
[TD="width: 65, align: right"]CASC.[/TD]
[TD="width: 65, align: right"]C[/TD]
[TD="width: 65, align: right"]D[/TD]
[TD="width: 65, align: right"]E[/TD]
[TD="width: 65, align: right"]F[/TD]
[TD="width: 65, align: right"]G[/TD]
[TD="width: 65, align: right"]H[/TD]
[TD="width: 65, align: right"]I[/TD]
[TD="width: 65, align: right"]L[/TD]
[TD="width: 65, align: right"]M[/TD]
[TD="width: 65"] N[/TD]
[TD="width: 65"] O[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]a[/TD]
[TD="align: right"]b[/TD]
[TD="align: right"]c[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]a[/TD]
[TD="align: right"]b[/TD]
[TD="align: right"]c[/TD]
[TD="align: right"]e[/TD]
[TD="align: right"]f[/TD]
[TD="align: right"]g[/TD]
[TD="align: right"]e1[/TD]
[TD="align: right"]f1[/TD]
[TD="align: right"]g1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]e[/TD]
[TD="align: right"]f[/TD]
[TD="align: right"]g[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]112[/TD]
[TD="align: right"]a[/TD]
[TD="align: right"]b[/TD]
[TD="align: right"]c[/TD]
[TD="align: right"]e[/TD]
[TD="align: right"]f[/TD]
[TD="align: right"]g[/TD]
[TD="align: right"]e1[/TD]
[TD="align: right"]f1[/TD]
[TD="align: right"]g1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]e1[/TD]
[TD="align: right"]f1[/TD]
[TD="align: right"]g1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]115[/TD]
[TD="align: right"]a[/TD]
[TD="align: right"]b[/TD]
[TD="align: right"]c[/TD]
[TD="align: right"]e[/TD]
[TD="align: right"]f[/TD]
[TD="align: right"]g[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"]112[/TD]
[TD="align: right"]a[/TD]
[TD="align: right"]b[/TD]
[TD="align: right"]c[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]165[/TD]
[TD="align: right"]a[/TD]
[TD="align: right"]b[/TD]
[TD="align: right"]c[/TD]
[TD="align: right"]e[/TD]
[TD="align: right"]f[/TD]
[TD="align: right"]g[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]e[/TD]
[TD="align: right"]f[/TD]
[TD="align: right"]g[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]a[/TD]
[TD="align: right"]b[/TD]
[TD="align: right"]c[/TD]
[TD="align: right"]e[/TD]
[TD="align: right"]f[/TD]
[TD="align: right"]g[/TD]
[TD="align: right"]e1[/TD]
[TD="align: right"]f1[/TD]
[TD="align: right"]g1[/TD]
[TD="align: right"]e[/TD]
[TD="align: right"]f[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]RAW DATA[/TD]
[TD="align: right"][/TD]
[TD="align: right"]e1[/TD]
[TD="align: right"]f1[/TD]
[TD="align: right"]g1[/TD]
[TD="class: xl63, colspan: 2, align: right"]SOLUTION ->[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"]115[/TD]
[TD="align: right"]a[/TD]
[TD="align: right"]b[/TD]
[TD="align: right"]c[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]e[/TD]
[TD="align: right"]f[/TD]
[TD="align: right"]g[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"]165[/TD]
[TD="align: right"]a[/TD]
[TD="align: right"]b[/TD]
[TD="align: right"]c[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]e[/TD]
[TD="align: right"]f[/TD]
[TD="align: right"]g[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]a[/TD]
[TD="align: right"]b[/TD]
[TD="align: right"]c[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]e[/TD]
[TD="align: right"]f[/TD]
[TD="align: right"]g[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]e1[/TD]
[TD="align: right"]f1[/TD]
[TD="align: right"]g1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]e[/TD]
[TD="align: right"]f[/TD]
[TD="align: right"]g[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]


could someone help me?
Thank you very much for your help.

Maurizio
 
Last edited:
Sort by date Sort by votes
mauriziosessa,

Sample raw data:


Excel 2007
BCDEFGHIJKLMN
1101abc
2efg
3e1f1g1
4112abc
5efg
6e1f1g1
7115abc
8efg
9165abc
10efg
11101abc
12efg
13e1f1g1
14efg
15
Sheet1


After the macro using two arrays in memory:


Excel 2007
BCDEFGHIJKLMN
1101abcefge1f1g1
2112abcefge1f1g1
3115abcefg
4165abcefg
5101abcefge1f1g1efg
6
7
8
9
10
11
12
13
14
15
Sheet1


Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

1. Copy the below code
2. Open your NEW workbook
3. Press the keys ALT + F11 to open the Visual Basic Editor
4. Press the keys ALT + I to activate the Insert menu
5. Press M to insert a Standard Module
6. Where the cursor is flashing, paste the code
7. Press the keys ALT + Q to exit the Editor, and return to Excel
8. To run the macro from Excel press ALT + F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

Code: 
Sub ReorgData()
' hiker95, 08/13/2014, ME798750
Dim mc As Long, n As Long, sr As Long, er As Long
Dim lr As Long, lc As Long, nc As Long
Dim b As Variant, o As Variant
Dim i As Long, j As Long, c As Long
Application.ScreenUpdating = False
lr = Cells(Rows.Count, "C").End(xlUp).Row
lc = Cells(1, Columns.Count).End(xlToLeft).Column
b = Range(Cells(1, 2), Cells(lr, lc))
sr = 1
For i = 2 To lr Step 1
  If b(i, 1) = "" And i <> lr Then
    er = i + 1
  ElseIf b(i, 1) <> "" Then
    If er - sr > mc Then mc = er - sr
    sr = i
  ElseIf b(i, 1) = "" And i = lr Then
    er = lr + 1
    If er - sr > mc Then mc = er - sr
  End If
Next i
n = Application.Count(Range("B1:B" & lr))
ReDim o(1 To n, 1 To (mc * (lc - 1)))
For i = 1 To lr Step 1
  If b(i, 1) <> "" Then
    nc = 0
     j = j + 1
    For c = 1 To UBound(b, 2)
      nc = nc + 1
      o(j, nc) = b(i, c)
    Next c
  Else
    For c = 2 To UBound(b, 2)
      nc = nc + 1
      o(j, nc) = b(i, c)
    Next c
  End If
Next i
Range(Cells(1, 2), Cells(lr, lc)).ClearContents
Range("B1").Resize(UBound(o, 1), UBound(o, 2)) = o
Columns(2).Resize(, UBound(o, 2)).AutoFit
Application.ScreenUpdating = True
End Sub

Before you use the macro with Excel 2007 or newer, save your workbook, Save As, a macro enabled workbook with the file extension .xlsm

Then run the ReorgData macro.
 
Upvote 0
FIRST ISSUE SOLVED - Re: Excel 2010 - Traspose lowest row to upper row

Hi hiker 95,
thank you very much for your help, it works great on my worksheet.

Could I ask you to explain me how this macro work?
i don't understand the code, because i would to use this macro on this dataset but it give me "Runtime error 9"


Code: 
[B][COLOR=#ff0000]RAW DATA[/COLOR][/B]

[TABLE="class: grid, width: 901, align: center"]
<tbody>[TR]
[TD="width: 53"]COD. SEGN.[/TD]
[TD="width: 53"]INSERITA DA[/TD]
[TD="width: 53"]DATA REAZIONE[/TD]
[TD="width: 53"]ETA'[/TD]
[TD="width: 53"]SESSO[/TD]
[TD="width: 53"]REGIONE[/TD]
[TD="width: 53"]GRAVITA'[/TD]
[TD="width: 53"]ESITO[/TD]
[TD="width: 53"]FONTE[/TD]
[TD="width: 53"]ART[/TD]
[TD="width: 53"]TIPO SOMM.[/TD]
[TD="width: 53"]SM/PA[/TD]
[TD="width: 53"]INDICAZIONE TERAPEUTICA[/TD]
[TD="width: 53"]POSOLOGIA[/TD]
[TD="width: 53"]DURATA TERAPIA[/TD]
[TD="width: 53"]CAUSA REAZIONE[/TD]
[TD="width: 53"]ATC[/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[TD]AZIENDA[/TD]
[TD] 12/10/2010[/TD]
[TD]46 anni[/TD]
[TD]F[/TD]
[TD]CAMPANIA[/TD]
[TD]GRAVE - OSPEDALIZZAZIONE O PROLUNGAMENTO OSPEDALIZZAZIONE[/TD]
[TD]RISOLUZIONE COMPLETA ADR IL[/TD]
[TD]MEDICO OSPEDALIERO[/TD]
[TD]Ileo paralitico[/TD]
[TD]S[/TD]
[TD]VINCRISTINA PFIZER ITALIA[/TD]
[TD]10067070 - Linfoma a cellule B - Linfoma non Hodgkin a cellule B  follicolari[/TD]
[TD]2 MILLIGRAMMI TOTALE[/TD]
[TD="colspan: 2"]Da 04/10/2010 A 04/10/2010[/TD]
[TD]Vincristina[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[TD]CICLOFOSFAMIDE[/TD]
[TD]10067070 - Linfoma a cellule B - Linfoma non Hodgkin a cellule B  follicolari[/TD]
[TD][/TD]
[TD="colspan: 2"]Da 04/10/2010 A 04/10/2010[/TD]
[TD]Farmaci antineoplastici e immunomodulatori[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[TD]DOXORUBICINA CLORIDRATO[/TD]
[TD]10067070 - Linfoma a cellule B - Linfoma non Hodgkin a cellule B  follicolari[/TD]
[TD][/TD]
[TD="colspan: 2"]Da 04/10/2010 A 04/10/2010[/TD]
[TD]Farmaci antineoplastici e immunomodulatori[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[TD]PREDNISONE[/TD]
[TD]10067070 - Linfoma a cellule B - Linfoma non Hodgkin a cellule B  follicolari[/TD]
[TD][/TD]
[TD="colspan: 2"]Da 04/10/2010 A 08/10/2010[/TD]
[TD]Preparati ormonali sistemici, esclusi gli ormoni sessuali[/TD]
[/TR]
[TR]
[TD="align: right"]14[/TD]
[TD]AZIENDA[/TD]
[TD] 16/11/2010[/TD]
[TD]77 anni[/TD]
[TD]M[/TD]
[TD]CAMPANIA[/TD]
[TD]NON GRAVE[/TD]
[TD]RISOLUZIONE COMPLETA ADR IL[/TD]
[TD]MEDICO OSPEDALIERO[/TD]
[TD]Follicolite, Eruzione cutanea[/TD]
[TD]S[/TD]
[TD]SUTENT, 30 CAPSULE "30 CAPSULE DA 25 MG"[/TD]
[TD]10007404 - Cancro del rene - Carcinoma del rene[/TD]
[TD]50 MILLIGRAMMI CICLICA[/TD]
[TD="colspan: 2"]Da 01/11/2010 A 16/11/2010[/TD]
[TD]SUNITINIB[/TD]
[/TR]
[TR]
[TD="align: right"]159[/TD]
[TD]AZIENDA[/TD]
[TD] 30/12/2010[/TD]
[TD]61 anni[/TD]
[TD]F[/TD]
[TD]CAMPANIA[/TD]
[TD]NON GRAVE[/TD]
[TD]MIGLIORAMENTO[/TD]
[TD]MEDICO OSPEDALIERO[/TD]
[TD]Dolore lombare, Nausea[/TD]
[TD]S[/TD]
[TD]TAXOTERE[/TD]
[TD]10006187 - Cancro della mammella - Cancro della mammella[/TD]
[TD]125 MILLIGRAMMI CICLICA[/TD]
[TD="colspan: 2"]Da 30/12/2010 A 30/12/2010[/TD]
[TD]Docetaxel[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[TD]EUTIROX, "100 MICROGRAMMI COMPRESSE" 50 COMPRESSE[/TD]
[TD][/TD]
[TD]100 MILLIGRAMMI[/TD]
[TD][/TD]
[TD][/TD]
[TD]Levotiroxina sodica[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[TD]INDERAL, "40 MG COMPRESSE" 30 COMPRESSE[/TD]
[TD][/TD]
[TD]40 MILLIGRAMMI[/TD]
[TD][/TD]
[TD][/TD]
[TD]Propranololo[/TD]
[/TR]
</tbody>[/TABLE]

Code: 
[B][COLOR=#00ff00]
SOLUTION[/COLOR][/B]

[TABLE="class: grid, width: 2470, align: center"]
<tbody>[TR]
[TD="width: 65"]COD. SEGN.[/TD]
[TD="width: 65"]INSERITA DA[/TD]
[TD="width: 65"]DATA REAZIONE[/TD]
[TD="width: 65"]ETA'[/TD]
[TD="width: 65"]SESSO[/TD]
[TD="width: 65"]REGIONE[/TD]
[TD="width: 65"]GRAVITA'[/TD]
[TD="width: 65"]ESITO[/TD]
[TD="width: 65"]FONTE[/TD]
[TD="width: 65"]ART[/TD]
[TD="width: 65"]TIPO SOMM.[/TD]
[TD="width: 65"]SM/PA[/TD]
[TD="width: 65"]INDICAZIONE TERAPEUTICA[/TD]
[TD="width: 65"]POSOLOGIA[/TD]
[TD="width: 65"]DURATA TERAPIA[/TD]
[TD="width: 65"]CAUSA REAZIONE[/TD]
[TD="width: 65"]ATC[/TD]
[TD="width: 65"]TIPO SOMM.[/TD]
[TD="width: 65"]SM/PA[/TD]
[TD="width: 65"]INDICAZIONE TERAPEUTICA[/TD]
[TD="width: 65"]POSOLOGIA[/TD]
[TD="width: 65"]DURATA TERAPIA[/TD]
[TD="width: 65"]CAUSA REAZIONE[/TD]
[TD="width: 65"]ATC[/TD]
[TD="width: 65"]TIPO SOMM.[/TD]
[TD="width: 65"]SM/PA[/TD]
[TD="width: 65"]INDICAZIONE TERAPEUTICA[/TD]
[TD="width: 65"]POSOLOGIA[/TD]
[TD="width: 65"]DURATA TERAPIA[/TD]
[TD="width: 65"]CAUSA REAZIONE[/TD]
[TD="width: 65"]ATC[/TD]
[TD="width: 65"]TIPO SOMM.[/TD]
[TD="width: 65"]SM/PA[/TD]
[TD="width: 65"]INDICAZIONE TERAPEUTICA[/TD]
[TD="width: 65"]POSOLOGIA[/TD]
[TD="width: 65"]DURATA TERAPIA[/TD]
[TD="width: 65"]CAUSA REAZIONE[/TD]
[TD="width: 65"]ATC[/TD]
[/TR]
[TR]
[TD="align: right"]131553[/TD]
[TD]AZIENDA[/TD]
[TD] 12/10/2010[/TD]
[TD]46 anni[/TD]
[TD]F[/TD]
[TD]CAMPANIA[/TD]
[TD]GRAVE - OSPEDALIZZAZIONE O PROLUNGAMENTO OSPEDALIZZAZIONE[/TD]
[TD]RISOLUZIONE COMPLETA ADR IL[/TD]
[TD]MEDICO OSPEDALIERO[/TD]
[TD]Ileo paralitico[/TD]
[TD]S[/TD]
[TD]VINCRISTINA PFIZER ITALIA[/TD]
[TD]10067070 - Linfoma a cellule B - Linfoma non Hodgkin a cellule B  follicolari[/TD]
[TD]2 MILLIGRAMMI TOTALE[/TD]
[TD="colspan: 2"]Da 04/10/2010 A 04/10/2010[/TD]
[TD]Vincristina[/TD]
[TD]C[/TD]
[TD]CICLOFOSFAMIDE[/TD]
[TD]10067070 - Linfoma a cellule B - Linfoma non Hodgkin a cellule B  follicolari[/TD]
[TD][/TD]
[TD="colspan: 2"]Da 04/10/2010 A 04/10/2010[/TD]
[TD]Farmaci antineoplastici e immunomodulatori[/TD]
[TD]C[/TD]
[TD]DOXORUBICINA CLORIDRATO[/TD]
[TD]10067070 - Linfoma a cellule B - Linfoma non Hodgkin a cellule B  follicolari[/TD]
[TD][/TD]
[TD="colspan: 2"]Da 04/10/2010 A 04/10/2010[/TD]
[TD]Farmaci antineoplastici e immunomodulatori[/TD]
[TD]C[/TD]
[TD]PREDNISONE[/TD]
[TD]10067070 - Linfoma a cellule B - Linfoma non Hodgkin a cellule B  follicolari[/TD]
[TD][/TD]
[TD="colspan: 2"]Da 04/10/2010 A 08/10/2010[/TD]
[TD]Preparati ormonali sistemici, esclusi gli ormoni sessuali[/TD]
[/TR]
[TR]
[TD="align: right"]131557[/TD]
[TD]AZIENDA[/TD]
[TD] 16/11/2010[/TD]
[TD]77 anni[/TD]
[TD]M[/TD]
[TD]CAMPANIA[/TD]
[TD]NON GRAVE[/TD]
[TD]RISOLUZIONE COMPLETA ADR IL[/TD]
[TD]MEDICO OSPEDALIERO[/TD]
[TD]Follicolite, Eruzione cutanea[/TD]
[TD]S[/TD]
[TD]SUTENT, 30 CAPSULE "30 CAPSULE DA 25 MG"[/TD]
[TD]10007404 - Cancro del rene - Carcinoma del rene[/TD]
[TD]50 MILLIGRAMMI CICLICA[/TD]
[TD="colspan: 2"]Da 01/11/2010 A 16/11/2010[/TD]
[TD]SUNITINIB[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]131559[/TD]
[TD]AZIENDA[/TD]
[TD] 30/12/2010[/TD]
[TD]61 anni[/TD]
[TD]F[/TD]
[TD]CAMPANIA[/TD]
[TD]NON GRAVE[/TD]
[TD]MIGLIORAMENTO[/TD]
[TD]MEDICO OSPEDALIERO[/TD]
[TD]Dolore lombare, Nausea[/TD]
[TD]S[/TD]
[TD]TAXOTERE[/TD]
[TD]10006187 - Cancro della mammella - Cancro della mammella[/TD]
[TD]125 MILLIGRAMMI CICLICA[/TD]
[TD="colspan: 2"]Da 30/12/2010 A 30/12/2010[/TD]
[TD]Docetaxel[/TD]
[TD]C[/TD]
[TD]EUTIROX, "100 MICROGRAMMI COMPRESSE" 50 COMPRESSE[/TD]
[TD][/TD]
[TD]100 MILLIGRAMMI[/TD]
[TD][/TD]
[TD][/TD]
[TD]Levotiroxina sodica[/TD]
[TD]C[/TD]
[TD]INDERAL, "40 MG COMPRESSE" 30 COMPRESSE[/TD]
[TD][/TD]
[TD]40 MILLIGRAMMI[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]Propranololo[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Thanks again,
Maurizio
 
Upvote 0
Re: FIRST ISSUE SOLVED - Re: Excel 2010 - Traspose lowest row to upper row

mauriziosessa,

thank you very much for your help, it works great on my worksheet.
Click to expand...

You are very welcome. Glad I could help.

The code works great on the raw data that I used.


It is always best to display your actual raw data worksheet(s), and, the results that you are looking for. This way we can usually find a solution on the first go.

Be back in a little while with a macro to work on your actual raw data.
 
Upvote 0
Re: FIRST ISSUE SOLVED - Re: Excel 2010 - Traspose lowest row to upper row

hi hiker95,
best to display your actual raw data worksheet
Click to expand...
, you are right i wanted to simplify the data in order to ensure a better understand of the problem, but it failed unfortunately.
The worksheet that i posted in the reply is only a part of a greater file (same structure, same column name, same data but only more row). Should i post the file ?

Thanks again, for your help, and for welcome (great community !)
Maurizio
 
Last edited:
Upvote 0
Re: FIRST ISSUE SOLVED - Re: Excel 2010 - Traspose lowest row to upper row

mauriziosessa,

I can not understand the language?

And, your new raw data is huge because of the long text in each cell, and, because of the number of columns.


In order to continue can you do the following:

Change all the text in each cell in in your screenshots BLUE to the text in YELLOW?


Excel 2007
ABCDEFG
1COD. SEGN.INSERITA DADATA REAZIONEETA'SESSOREGIONEGRAVITA'
213AZIENDA12/10/201046 anniFCAMPANIAGRAVE - OSPEDALIZZAZIONE O PROLUNGAMENTO OSPEDALIZZAZIONE
3
4
5
6C SI DD RETA'SRG
713A12/10/201046 anniFCG - O O P O
8
Sheet1_Questions



Then post the new screenshots.
 
Upvote 0
Re: FIRST ISSUE SOLVED - Re: Excel 2010 - Traspose lowest row to upper row

hikel95,

sure i could use a codebook like this:



Code:

RAW DATA[TABLE="class: cms_table_grid, width: 901, align: center"]
<tbody>[TR]
[TD="width: 53"]C. S.[/TD]
[TD="width: 53"]I. D.[/TD]
[TD="width: 53"]D. R.[/TD]
[TD="width: 53"]E.[/TD]
[TD="width: 53"]S.[/TD]
[TD="width: 53"]R.[/TD]
[TD="width: 53"]G.[/TD]
[TD="width: 53"]E.[/TD]
[TD="width: 53"]F.[/TD]
[TD="width: 53"]ART[/TD]
[TD="width: 53"]T. S.[/TD]
[TD="width: 53"]SM/PA[/TD]
[TD="width: 53"]I. T.[/TD]
[TD="width: 53"]PO.[/TD]
[TD="width: 53"]D. T.[/TD]
[TD="width: 53"]C. R.[/TD]
[TD="width: 53"]ATC[/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[TD]1[/TD]
[TD] 12/10/2010[/TD]
[TD]46 a.[/TD]
[TD]F[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]Ileo paralitico[/TD]
[TD]S[/TD]
[TD]VINCRISTINA PFIZER ITALIA[/TD]
[TD]10067070[/TD]
[TD]2 MG TOT.[/TD]
[TD="colspan: 2"]Da 04/10/2010 A 04/10/2010[/TD]
[TD]Vincristina[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[TD]CICLOFOSFAMIDE[/TD]
[TD]10067070[/TD]
[TD][/TD]
[TD="colspan: 2"]Da 04/10/2010 A 04/10/2010[/TD]
[TD]Farmaci antineoplastici e immunomodulatori[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[TD]DOXORUBICINA CLORIDRATO[/TD]
[TD]10067070[/TD]
[TD][/TD]
[TD="colspan: 2"]Da 04/10/2010 A 04/10/2010[/TD]
[TD]Farmaci antineoplastici e immunomodulatori[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[TD]PREDNISONE[/TD]
[TD]10067070[/TD]
[TD][/TD]
[TD="colspan: 2"]Da 04/10/2010 A 08/10/2010[/TD]
[TD]Preparati ormonali sistemici, esclusi gli ormoni sessuali[/TD]
[/TR]
[TR]
[TD="align: right"]14[/TD]
[TD]1[/TD]
[TD] 16/11/2010[/TD]
[TD]77 a.[/TD]
[TD]M[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]Follicolite, Eruzione cutanea[/TD]
[TD]S[/TD]
[TD]SUTENT, 30 CAPSULE "30 CAPSULE DA 25 MG"[/TD]
[TD]10007404[/TD]
[TD]50 MG CIC.[/TD]
[TD="colspan: 2"]Da 01/11/2010 A 16/11/2010[/TD]
[TD]SUNITINIB[/TD]
[/TR]
[TR]
[TD="align: right"]159[/TD]
[TD]1[/TD]
[TD] 30/12/2010[/TD]
[TD]61 a.[/TD]
[TD]F[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]Dolore lombare, Nausea[/TD]
[TD]S[/TD]
[TD]TAXOTERE[/TD]
[TD]10006187[/TD]
[TD]125 MG CIC.[/TD]
[TD="colspan: 2"]Da 30/12/2010 A 30/12/2010[/TD]
[TD]Docetaxel[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[TD]EUTIROX, "100 MICROGRAMMI COMPRESSE" 50 COMPRESSE[/TD]
[TD][/TD]
[TD]100 MG[/TD]
[TD][/TD]
[TD][/TD]
[TD]Levotiroxina sodica[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[TD]INDERAL, "40 MG COMPRESSE" 30 COMPRESSE[/TD]
[TD][/TD]
[TD]40 MG[/TD]
[TD][/TD]
[TD][/TD]
[TD]Propranololo[/TD]
[/TR]
</tbody>[/TABLE]


Code:

SOLUTION[TABLE="class: cms_table_grid, width: 2470, align: center"]
<tbody>[TR]
[TD="width: 65"]C. S.[/TD]
[TD="width: 65"]I. D.[/TD]
[TD="width: 65"]D. R.[/TD]
[TD="width: 65"]E.[/TD]
[TD="width: 65"]S.[/TD]
[TD="width: 65"]R.[/TD]
[TD="width: 65"]G.[/TD]
[TD="width: 65"]ES.[/TD]
[TD="width: 65"]F.[/TD]
[TD="width: 65"]ART[/TD]
[TD="width: 65"]T. S.[/TD]
[TD="width: 65"]SM/PA[/TD]
[TD="width: 65"]I. T.[/TD]
[TD="width: 65"]PO.[/TD]
[TD="width: 65"]D. T.[/TD]
[TD="width: 65"]C. R.[/TD]
[TD="width: 65"]ATC[/TD]
[TD="width: 65"]T. S.[/TD]
[TD="width: 65"]SM/PA[/TD]
[TD="width: 65"]I. T.[/TD]
[TD="width: 65"]PO.[/TD]
[TD="width: 65"]D. T.[/TD]
[TD="width: 65"]C. R.[/TD]
[TD="width: 65"]ATC[/TD]
[TD="width: 65"]T. S.[/TD]
[TD="width: 65"]SM/PA[/TD]
[TD="width: 65"]I. T.[/TD]
[TD="width: 65"]PO[/TD]
[TD="width: 65"]D. T.[/TD]
[TD="width: 65"]C. R.[/TD]
[TD="width: 65"]ATC[/TD]
[TD="width: 65"]T. S.[/TD]
[TD="width: 65"]SM/PA[/TD]
[TD="width: 65"]I. T.[/TD]
[TD="width: 65"]PO.[/TD]
[TD="width: 65"]D. T.[/TD]
[TD="width: 65"]C. R.[/TD]
[TD="width: 65"]ATC[/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[TD]1[/TD]
[TD] 12/10/2010[/TD]
[TD]46 a.[/TD]
[TD]F[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]Ileo paralitico[/TD]
[TD]S[/TD]
[TD]VINCRISTINA PFIZER ITALIA[/TD]
[TD]10067070[/TD]
[TD]2 MG TOT[/TD]
[TD="colspan: 2"]Da 04/10/2010 A 04/10/2010[/TD]
[TD]Vincristina[/TD]
[TD]C[/TD]
[TD]CICLOFOSFAMIDE[/TD]
[TD]10067070[/TD]
[TD][/TD]
[TD="colspan: 2"]Da 04/10/2010 A 04/10/2010[/TD]
[TD]Farmaci antineoplastici e immunomodulatori[/TD]
[TD]C[/TD]
[TD]DOXORUBICINA CLORIDRATO[/TD]
[TD]10067070[/TD]
[TD][/TD]
[TD="colspan: 2"]Da 04/10/2010 A 04/10/2010[/TD]
[TD]Farmaci antineoplastici e immunomodulatori[/TD]
[TD]C[/TD]
[TD]PREDNISONE[/TD]
[TD]10067070[/TD]
[TD][/TD]
[TD="colspan: 2"]Da 04/10/2010 A 08/10/2010[/TD]
[TD]Preparati ormonali sistemici, esclusi gli ormoni sessuali[/TD]
[/TR]
[TR]
[TD="align: right"]14[/TD]
[TD]1[/TD]
[TD] 16/11/2010[/TD]
[TD]77 a.[/TD]
[TD]M[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]Follicolite, Eruzione cutanea[/TD]
[TD]S[/TD]
[TD]SUTENT, 30 CAPSULE "30 CAPSULE DA 25 MG"[/TD]
[TD]10007404[/TD]
[TD]50 MG CIC[/TD]
[TD="colspan: 2"]Da 01/11/2010 A 16/11/2010[/TD]
[TD]SUNITINIB[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]159[/TD]
[TD]1[/TD]
[TD] 30/12/2010[/TD]
[TD]61 a.[/TD]
[TD]F[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]Dolore lombare, Nausea[/TD]
[TD]S[/TD]
[TD]TAXOTERE[/TD]
[TD]10006187[/TD]
[TD]125 MG CIC[/TD]
[TD="colspan: 2"]Da 30/12/2010 A 30/12/2010[/TD]
[TD]Docetaxel[/TD]
[TD]C[/TD]
[TD]EUTIROX, "100 MICROGRAMMI COMPRESSE" 50 COMPRESSE[/TD]
[TD][/TD]
[TD]100 MG[/TD]
[TD][/TD]
[TD][/TD]
[TD]Levotiroxina sodica[/TD]
[TD]C[/TD]
[TD]INDERAL, "40 MG COMPRESSE" 30 COMPRESSE[/TD]
[TD][/TD]
[TD]40 MG[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]Propranololo[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



I.D column:
1= Azienda

R. column:
1 = Campania

G. column:
1 = GRAVE - OSPEDALIZZAZIONE O PROLUNGAMENTO OSPEDALIZZAZIONE
2 = NON GRAVE

ES. column:
1 = RISOLUZIONE COMPLETA ADR IL
2 = MIGLIORAMENTO

F. column:
1 = MEDICO OSPEDALIERO

I.T. column:
10067070 = Linfoma a cellule B - Linfoma non Hodgkin a cellule B follicolari
10007404 = Cancro del rene - Carcinoma del rene
10006187 = Cancro della mammella - Cancro della mammella

PO. column:
MG = MILLIGRAMMI
CIC = CICLICA
TOT= TOTALE
 
Last edited:
Upvote 0
Re: FIRST ISSUE SOLVED - Re: Excel 2010 - Traspose lowest row to upper row

mauriziosessa,

One last try.

I need all the text in all the cells in your screenshots to be reduced/shortened like the BLUE text examples.
 
Last edited:
Upvote 0
Re: FIRST ISSUE SOLVED - Re: Excel 2010 - Traspose lowest row to upper row

ok, i will try
it's ok like this ?

Code:

SOLUTION[TABLE="class: cms_table_cms_table_grid, width: 2470, align: center"]
<tbody>[TR]
[TD="width: 65"]C. S.[/TD]
[TD="width: 65"]I. D.[/TD]
[TD="width: 65"]D. R.[/TD]
[TD="width: 65"]E.[/TD]
[TD="width: 65"]S.[/TD]
[TD="width: 65"]R.[/TD]
[TD="width: 65"]G.[/TD]
[TD="width: 65"]ES.[/TD]
[TD="width: 65"]F.[/TD]
[TD="width: 65"]ART[/TD]
[TD="width: 65"]T. S.[/TD]
[TD="width: 65"]SM. PA.[/TD]
[TD="width: 65"]I. T.[/TD]
[TD="width: 65"]PO.[/TD]
[TD="width: 65"]D. T.[/TD]
[TD="width: 65"]C. R.[/TD]
[TD="width: 65"]ATC[/TD]
[TD="width: 65"]T. S.[/TD]
[TD="width: 65"]SM. PA.[/TD]
[TD="width: 65"]I. T.[/TD]
[TD="width: 65"]PO.[/TD]
[TD="width: 65"]D. T.[/TD]
[TD="width: 65"]C. R.[/TD]
[TD="width: 65"]ATC[/TD]
[TD="width: 65"]T. S.[/TD]
[TD="width: 65"]SM. PA.[/TD]
[TD="width: 65"]I. T.[/TD]
[TD="width: 65"]PO[/TD]
[TD="width: 65"]D. T.[/TD]
[TD="width: 65"]C. R.[/TD]
[TD="width: 65"]ATC[/TD]
[TD="width: 65"]T. S.[/TD]
[TD="width: 65"]SM. PA.[/TD]
[TD="width: 65"]I. T.[/TD]
[TD="width: 65"]PO.[/TD]
[TD="width: 65"]D. T.[/TD]
[TD="width: 65"]C. R.[/TD]
[TD="width: 65"]ATC[/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[TD]1[/TD]
[TD]12/10/2010[/TD]
[TD]46 a.[/TD]
[TD]F[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]S[/TD]
[TD]1[/TD]
[TD]10067070[/TD]
[TD]2 MG TOT[/TD]
[TD="colspan: 2"]Da 04/10/2010 A 04/10/2010[/TD]
[TD]1[/TD]
[TD]C[/TD]
[TD]4[/TD]
[TD]10067070[/TD]
[TD][/TD]
[TD="colspan: 2"]Da 04/10/2010 A 04/10/2010[/TD]
[TD]4[/TD]
[TD]C[/TD]
[TD]6[/TD]
[TD]10067070[/TD]
[TD][/TD]
[TD="colspan: 2"]Da 04/10/2010 A 04/10/2010[/TD]
[TD]4[/TD]
[TD]C[/TD]
[TD]8[/TD]
[TD]10067070[/TD]
[TD][/TD]
[TD="colspan: 2"]Da 04/10/2010 A 08/10/2010[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD="align: right"]14[/TD]
[TD]1[/TD]
[TD]16/11/2010[/TD]
[TD]77 a.[/TD]
[TD]M[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]2, 3[/TD]
[TD]S[/TD]
[TD]2[/TD]
[TD]10007404[/TD]
[TD]50 MG CIC[/TD]
[TD="colspan: 2"]Da 01/11/2010 A 16/11/2010[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]159[/TD]
[TD]1[/TD]
[TD]30/12/2010[/TD]
[TD]61 a.[/TD]
[TD]F[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]4, 5[/TD]
[TD]S[/TD]
[TD]3[/TD]
[TD]10006187[/TD]
[TD]125 MG CIC[/TD]
[TD="colspan: 2"]Da 30/12/2010 A 30/12/2010[/TD]
[TD]3[/TD]
[TD]C[/TD]
[TD]5[/TD]
[TD][/TD]
[TD]100 MG[/TD]
[TD][/TD]
[TD][/TD]
[TD]5[/TD]
[TD]C[/TD]
[TD]7[/TD]
[TD][/TD]
[TD]40 MG[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I.D column:
1= Azienda

R. column:
1 = Campania

G. column:
1 = GRAVE - OSPEDALIZZAZIONE O PROLUNGAMENTO OSPEDALIZZAZIONE
2 = NON GRAVE

ES. column:
1 = RISOLUZIONE COMPLETA ADR IL
2 = MIGLIORAMENTO

F. column:
1 = MEDICO OSPEDALIERO

I.T. column:
10067070 = Linfoma a cellule B - Linfoma non Hodgkin a cellule B follicolari
10007404 = Cancro del rene - Carcinoma del rene
10006187 = Cancro della mammella - Cancro della mammella

PO. column:
MG = MILLIGRAMMI
CIC = CICLICA
TOT= TOTALE

ART column:
Ileo paralitico = 1
Follicolite = 2
Eruzione cutanea = 3
Dolore lombare = 4
Nausea = 5

ATC column:
Vincristina = 1
SUNITINIB = 2
Docetaxel = 3
Farmaci antineoplastici e immunomodulatori = 4

Levotiroxina sodica = 5

Propranololo = 6
Preparati ormonali sistemici, esclusi gli ormoni sessuali = 7

SM/PA column:
VINCRISTINA PFIZER ITALIA = 1
SUTENT, 30 CAPSULE "30 CAPSULE DA 25 MG" = 2
TAXOTERE = 3
CICLOFOSFAMIDE = 4
EUTIROX, "100 MICROGRAMMI COMPRESSE" 50 COMPRESSE = 5

DOXORUBICINA CLORIDRATO = 6

INDERAL, "40 MG COMPRESSE" 30 COMPRESSE = 7
PREDNISONE = 8
 
Upvote 0
Re: FIRST ISSUE SOLVED - Re: Excel 2010 - Traspose lowest row to upper row

mauriziosessa,

I am still having a problem understanding what to do.

You may want to try posting your thread here:
http://www.mrexcel.com/forum/questions-other-languages/


Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question Question
Employee Sorting form to email.
Replies
2
Views
133
Justinjc79
J
A
  • Question Question
Excel Row
Replies
7
Views
220
Cubist
Cubist
R
  • Question Question
Send and email using an Outlook template
Replies
1
Views
665
Razor_Rob
R
M
  • Question Question
Excel entry slowed by Conditional Formatting
Replies
2
Views
54
moore315
M
P
  • Solved
CutList
Replies
3
Views
80
StephenCrump
S

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top