I have hundreds of rows/columns of data that I need to organize into one row per "issue." The raw data pulls data into multiple columns and rows, but I am trying to find an Index Match, or another formula that will put all data related to Issue #X into one row, recognize a blank row from the raw data, and put the next group of data into the next row.
Solved by C. Y. in 20 mins