Table manipulation

[#1]

Hello,

I have a table like this:

ID               Hour non attendance   Working Hours   Holydays Hour

BH123                   10                             56                    50

DG566                    5                              36                    32

HJ5632                    3                             80                    36

HU8969                   8                             70                    25

And I need to creat a table IN THE SCRIPT like below:

ID                      HOUR TYPE                                          Number

BH123         Hour non attendance                                        10

BH123          Working Hours                                                 56

BH123           Holydays Hour                                                  50

DG566          Hour non attendance                                               5

etc....

.

.

.

.

Does anyone have an idea please? Thanks you very much

[tresesco · Accepted solution]

Try like:

Crosstable ( [HOUR TYPE], Number)

     Load

              *

From <>; 

[#3]

Its working thank you so much