Open Excel and add a new column to the left of the data range you want to convert to a single column. Do this by selecting the far left column, clicking on it and then clicking "Insert" in the ...

Finally, a PivotTable will return stipend totals earned for each employee by employee and date. I’m using Office 365’s Excel (desktop), but you can use earlier versions.

You can use Excel, Microsoft's spreadsheet program, to store, organize, and analyze data in a number of ways.