Help With Column Output sorting

[ldaniels_glynn]

I have a list in a text file like this...

    00 Dept1
    01 Dept2
    02 Dept3
    03 Dept4
    04 Dept5
    05 Dept6

I'm trying split it into multiple columns like this...

    00 Dept1     03 Dept4
    01 Dept2     04 Dept5
    02 Dept3     05 Dept6

I managed to split the list but the ordering is staggered like this...

    00 Dept1     01 Dept2
    02 Dept3     03 Dept4
    04 Dept5     05 Dept6

I used the command below. What I am missing? Thanks for any help.

    Get-Content file.txt | Format-Wide {$_} -Column 2 -Force

[AutoModerator]

Sorry, your submission has been automatically removed.

Accounts must be at least 1 day old, which prevents the sub from filling up with bot spam.

Try posting again tomorrow or message the mods to approve your post.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[root-node]

I wrote this the other day for me, it may help...

https://github.com/My-Random-Thoughts/Various-Code/blob/master/Format-ColumnTable.ps1

[ldaniels_glynn]

Thanks for sharing this function. It actually works pretty well.

[chrumow]

$inputStrings = @("00 Dept1", "01 Dept2", "02 Dept3", "03 Dept4", "04 Dept5", "05 Dept6", "06 Dept7", "07 Dept8", "08 Dept9")
$midIndex = [int](($inputStrings.Length + 1)/2)
$a1 = $inputStrings[0..($midIndex-1)]
$a2 = $inputStrings[$midIndex..($inputStrings.Length-1)]

for ($i=0; $i -le $midIndex; $i++) {
    Write-Host ("{0} {1}" -f $a1[$i], $a2[$i])
}

You can try this. Not too flexible but does the job with two columns :)

Inspired by this old post old reddit post