Extract Values from Column based on Another Column

There are times when you get data from someone that's not in a spreadsheet but looks like it came from one. The file you get may be a text file, but it looks like it's almost in some table format and had some calculations. You'd want to take the data or content from the file and do further analysis, so that would involve putting it into Excel. If it was a small file, it's a simple copy and paste, but if it was a large file it would take a long time to copy/paste all that data. You can actually bring it into a spreadsheet but you'd first need to see if there were some patterns. Hopefully if someone gave you a text file that seems to have calculations in it, the file would have come from some application that did the calculation and uniformly had the output in some repeating format (like some dash marker to indicate a total row was next) then you could extract data based on a previous row. This video will show how to use values from one row to find a pattern, use some conditions to compare and extract it to make a new column to help make a proper table to support further analysis