Justin Cooney

Web Development Tips and Examples

about

I am a Senior Applications Programmer / Analyst with years of experience developing enterprise solutions using the Microsoft technology stack including C#, VB.NET, ASP.NET, AJAX, IIS and SQL Server. I specialize in Web application development with a focus on building secure systems, integrating applications, and designing robust database structures.

Category: Excel

Pivot a Row or Column of Data in Excel

2016-01-20

Excel is a great tool for data manipulation. One feature that can come in handy is the ability to pivot a data row into a column or pivot data in a column of information into a row.
Using ClosedXML.Excel with ASP.NET to Generate Excel Documents on the Fly

2015-10-08

I’ve been playing around with the ClosedXML.Excel library for creating or reading MS Excel documents in your ASP.NET code. Bottom line is that this tool is going to save you a lot of time: In simplifying your task of putting the Workbook and Worksheets together and I can’t stress enough how much time this will…
Skydrive Excel: Find Duplicates Between Two Columns

2014-01-14

There are some great ways to hunt down duplicate values in the desktop version of MS Excel. Today I will take a look at using the free online SkyDrive version of Excel that is integrated with Outlook.com to find duplicates between two columns.

recent posts

about

Category: Excel

Pivot a Row or Column of Data in Excel

Using ClosedXML.Excel with ASP.NET to Generate Excel Documents on the Fly

Skydrive Excel: Find Duplicates Between Two Columns