johnmpl
Board Regular
- Joined
- Jun 14, 2013
- Messages
- 237
- Office Version
- 365
- Platform
- Windows
Hi, to all!
I need to special unpivot some data.
Input:
<colgroup><col span="3"><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Output:
<colgroup><col><col span="2"><col span="2"><col></colgroup><tbody>
</tbody>
Appreciate all your help. Blessings!
I need to special unpivot some data.
Input:
NAMEA | NAMEB | NAMEC | DATE THING 1 | DESCRIPTION | DATE THING 2 | DESCRIPTION 2 | DATE THING 3 | DESCRIPTION 3 |
Name1 | Name28 | Name55 | 28/01/2019 | Descript 1 | 24/02/2019 | Descript 28 | 23/03/2019 | Descript 55 |
Name2 | Name29 | Name56 | 29/01/2019 | Descript 2 | 24/03/2019 | Descript 56 | ||
Name3 | Name30 | Name57 | 30/01/2019 | Descript 3 | 26/02/2019 | Descript 30 | ||
Name4 | Name31 | Name58 | 31/01/2019 | Descript 4 | ||||
Name5 | Name32 | Name59 | 28/02/2019 | Descript 32 | 27/03/2019 | Descript 59 |
<colgroup><col span="3"><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Output:
NAMEA | NAMEB | NAMEC | TYPE | DATE | DESCRIPTION |
Name1 | Name28 | Name55 | THING 1 | 28/01/2019 | Descript 1 |
Name1 | Name28 | Name55 | THING 2 | 24/02/2019 | Descript 28 |
Name1 | Name28 | Name55 | THING 3 | 23/03/2019 | Descript 55 |
Name2 | Name29 | Name56 | THING 1 | 29/01/2019 | Descript 2 |
Name2 | Name29 | Name56 | THING 3 | 24/03/2019 | Descript 56 |
Name3 | Name30 | Name57 | THING 1 | 30/01/2019 | Descript 3 |
Name3 | Name30 | Name57 | THING 2 | 26/02/2019 | Descript 30 |
Name4 | Name31 | Name58 | THING 1 | 31/01/2019 | Descript 4 |
Name5 | Name32 | Name59 | THING 2 | 28/02/2019 | Descript 32 |
Name5 | Name32 | Name59 | THING 3 | 27/03/2019 | Descript 59 |
<colgroup><col><col span="2"><col span="2"><col></colgroup><tbody>
</tbody>
Appreciate all your help. Blessings!