My spreadsheet of 700 rows looks like Table1 and I must create a report formatted as Table2. I'm having no success with pivot tables and know no other way. The File#'s each have between 1 and 15 rows of Content. Can anyone help? I'm using Excel 2007. Thanks!
<TBODY>
</TBODY>
<TBODY>
</TBODY>
Table | 1 |
File# | Content |
1001 | aaaa |
1001 | bbbb |
1001 | cccc |
2002 | xxxx |
2002 | yyyy |
2002 | zzzz |
<TBODY>
</TBODY>
Table | 2 | ||
File # | Content-1 | Content-2 | Content-3 |
1001 | aaaaa | bbbb | cccc |
2002 | xxxx | yyyy | zzzz |
<TBODY>
</TBODY>