vrsrinivas2000 Posted August 30, 2019 Share Posted August 30, 2019 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. Link to comment Share on other sites More sharing options...
water Posted August 30, 2019 Share Posted August 30, 2019 Should be possible. What have you tried so far? My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
vrsrinivas2000 Posted August 30, 2019 Author Share Posted August 30, 2019 (edited) #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 Link to comment Share on other sites More sharing options...
Developers Jos Posted August 30, 2019 Developers Share Posted August 30, 2019 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 SciTE4AutoIt3 Full installer Download page - Beta files Read before posting How to post scriptsource Forum etiquette Forum Rules Live for the present, Dream of the future, Learn from the past. Link to comment Share on other sites More sharing options...
water Posted August 30, 2019 Share Posted August 30, 2019 #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) My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now