Powershell copy a column from a csv file and paste into the first row of another csv file

I have a csv file named "final results.csv", there is a header row and some data. The header data are "Alias" with underscores, for example User_Name, User_Age, User_firstN, User_LastN

I have another csv file named "header names.csv" where the actual name of the headers are stored. It has one single column, so the data looks like this.

Header  User Name  User Age  First Name  Last Name

The goal is to extract the header actual names from the 2nd file, and paste them into the first row of the first file. So the first file ("final results.csv") has a header with actual header names as opposed to aliases.

How do I achived this using Powershell? Thanks in advance!

https://stackoverflow.com/questions/66927110/powershell-copy-a-column-from-a-csv-file-and-paste-into-the-first-row-of-another April 03, 2021 at 09:57AM