How can I easily transform columns information to CSV line or file output?
Input (From file or excel column):
ABC1
ABC2
ABC3
ABC4
Output (To file or excel line):
ABC21,ABC2,ABC3,ABC4
I don't want to use VBScripting in Excel, I just want a very simple way to do it. Yet, if possible/known, I would not discard a powershell script to do so.
Thanks!
EDIT: Managed to do it in the most stupid way possible, transposed the column range into row range then saved it as CSV.