Convert Excel data to a flat file
Posted on 2014-02-24
I have an excel sheet that I want to flatten out into a CVS so that I can import into Google calendar.
The purpose of this spreadsheet is to take a class roster and assign individuals tasks. In order to bring it into Google Calendar, it has to be flattened out.
Here is the format of the sheet.
Date Topic 1 Topic 2 Topic 3 Topic 4
3/1/14 John Ed Bob Jim
3/2/14 Steve Joe Mary Larry
Results should look like this:
3/1/14 Topic 1 John
3/1/14 Topic 2 Ed
3/1/14 Topic 3 Bob
3/1/14 Topic 4 Jim
3/2/14 Topic 1 Steve
3/2/14 Topic 2 Joe
3/2/14 Topic 3 Mary
3/2/14 Topic 4 Larry
Hope this is enough information to help