I am not the original creator of the spreadsheet so I am not sure how the person caused this. The issue is basically the excel spreadsheet has an excess amount of empty cells that won't delete and ...
I need the values in one column to be rearranged for each set into another column. This picture will help explain: Follow the red lines, that is where I want my data to go. This shouldn't be too ...
Okay this is hard to explain. I have a massive spreadsheet with sets of data in it. Each set has 'type' column (eg: system, memory, video card, etc). I need to be able to search within this column ...