00:00I'm going to overcomplicate Excel's simple dataset by converting it into a comma-separated file,
00:05also known as CSV file. For everyone's benefit, a CSV file is a text format for storing tabular
00:11data with rows separated by comma. For this dataset, we can format it into a CSV file using
00:16a text join function with comma being the delimiter, ignore empty cells, and specify the
00:21range A3 to D3. After that, apply the same formula to the rest of the rows. Then copy the content
00:26of
00:26this cell into another text file and you just have created yourself a CSV file. You might say,
00:31this can easily be done by using file, save as, browse, save it as CSV file, and job done, right?
00:37Not really. What if you require CSV formatted data for column A, C, and D only? You can continue
00:44utilizing the text join function with comma being a delimiter, ignoring empty cells, and specifying the
00:49cell A3, C3, and D3, close parenthesis, and enter. And after that, apply the same formula to the rest
00:56of the rows.
