Hello,
I have table: 3 cols and over 300k rows.
Col1 - ID (numeric id, ex: 123456)
Col2 - Numb (numeric from 1 to 25, ex: 1)
Col3 - Yes/no (0 or 1)
I have 443 unique IDs. Each ID has more than 400 rows, almost of all have different numbers of rows.
How to split initial table to table in this way:
Col1 - ID1
Col2 - ID2
..
Col443 - ID443
and fill it from 1 table (yes/no), 'Numb' is not valuable for the moment
and number of rows is 400 or the minimum of number of rows within ID.
so how to split it and finally cut excess ?
I have table: 3 cols and over 300k rows.
Col1 - ID (numeric id, ex: 123456)
Col2 - Numb (numeric from 1 to 25, ex: 1)
Col3 - Yes/no (0 or 1)
I have 443 unique IDs. Each ID has more than 400 rows, almost of all have different numbers of rows.
How to split initial table to table in this way:
Col1 - ID1
Col2 - ID2
..
Col443 - ID443
and fill it from 1 table (yes/no), 'Numb' is not valuable for the moment
and number of rows is 400 or the minimum of number of rows within ID.
so how to split it and finally cut excess ?