I have several text files that are organized like below
X: Y
B: C
G: F
and I need them to go into a csv file and look like
X,B,G
Y,C,F
Several rows of information separated by a ":" I need to take what is on the left make them into the top row of a CSV and then what is on the right into the CSV data. I am not a huge PowerShell scripting guy and this is time sensitive or else I would figure this out on my own and I haven't done a lot of manipulating text in Linux. This can be a Linux or Windows solution. I am researching this but if any of you have a solution that would be great. I am getting close but like I said time sensitive matter. Also, I have thousands of files I need to process so doing this by hand is out of the question.