Convert Specific Column data into row - (Moved)

[vrsrinivas2000]

Do we have any way change the specific column data into a row as below.

I have a data like below

Employee	Column1	Column2
1	20	50
2	30
3	40

And I need data as below

Employee	Column1
1	20
1	50
2	30
3	40

 

Thanks in adavance.

Srinivas.

[water]

Should be possible. What have you tried so far?

[vrsrinivas2000]

#include <Array.au3>

Local $aArray[4][4]
For $i = 0 To 3
    For $j = 0 To 3
        $aArray[$i][$j] = $i & $j
    Next
Next
_ArrayDisplay($aArray, "Original")

Local $aExtract = _ArrayExtract($aArray, 0, 3, 1, 1)
_ArrayDisplay($aExtract, "Row 0-3 column 1")

Local $aExtract = _ArrayExtract($aArray, 0, 3, 0, 0)
_ArrayDisplay($aExtract, "Row 0-3 column 0")

Local $aExtract = _ArrayExtract($aArray, 1, 1, 1, 3)
_ArrayDisplay($aExtract, "Row 1 column 1 - 3")

Local $aExtract = _ArrayExtract($aArray, 0, 0, 1, 3)
_ArrayDisplay($aExtract, "Row 0 column 1 - 3")

Edited August 30, 2019 by vrsrinivas2000

[Jos]

Moved to the appropriate forum, as the Developer General Discussion forum very clearly states:

Quote

General development and scripting discussions. If it's super geeky and you don't know where to put it - it's probably here.

---

Do not create AutoIt-related topics here, use the AutoIt General Help and Support or AutoIt Technical Discussion forums.

Moderation Team

[water]

#include <Array.au3>
Global $aInput[][] = [[1, 20, 50], [2, 30], [3, 40]]
Global $aOutput[UBound($aInput, 2) * 2][2]
_ArrayDisplay($aInput)
Global $iIndex = 0
For $i = 0 To UBound($aInput, 1) - 1
    For $j = 1 To UBound($aInput, 2) - 1
        if $aInput[$i][$j] = "" Then ContinueLoop
        $aOutput[$iIndex][0] = $aInput[$i][0]
        $aOutput[$iIndex][1] = $aInput[$i][$j]
        $iIndex = $iIndex + 1
    Next
Next
ReDim $aOutput[$iIndex][UBound($aOutput, 2)]
_ArrayDisplay($aOutput)