Cleaning Up CSV File with Different Blocks of Data
I have several csv files that need to be clean up. The files in question have two basic data block structures. The first block consist of 1 column with 7 rows of information. The second segment contains 6 columns with 5+ rows of data. For the first block, the ideal transformation is to break the column into two pieces. One piece will provide the header or name of the column. And, the second p...
mpatpc