Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all
i have data like attached below
Col1 | col2 | col3 | col4 | col5 | col6 | col7 | col8 | col9 | col10 |
a | 1 | x | 4 | d | 7 | g | xyz | aa | 0 |
b | 2 | y | 5 | e | 8 | h | xyz | bb | 0 |
c | 3 | z | 6 | f | 9 | i | xyz | cc | 0 |
in script level itself i need to convert my data like i attached below
Col1 | col2 | col3 | col4 | col5 | col6 | col7 | col8 | col9 | col10 |
a | 1 | x | 4 | d | 7 | g | xyz | aa | 0 |
Col1 | col2 | col3 | col4 | col5 | col6 | col7 | col8 | col9 | col10 |
b | 2 | y | 5 | e | 8 | h | xyz | bb | 0 |
Col1 | col2 | col3 | col4 | col5 | col6 | col7 | col8 | col9 | col10 |
c | 3 | z | 6 | f | 9 | i | xyz | cc | 0 |
any idea!!!!
thanks
Can u pls tell me the purpose of this? there could be som other ways or funtions to fulfill ur requirement. instead of putting the field names in the alternate rows.
Can u pls explain the req?
-Sundar
i need to give this as a text file... they need to use this as a input data to some other system that why
Pls share a sample source file.
-sundar
pfa