On Thu, Apr 23, 2009 at 12:09 PM, Sergio Abadesso < groups.abade...@googlemail.com> wrote:
> Hi gabo, > > it is possible to let look like the data of the upper example like yours > below. > > Take a look in the Excel help by searching for "Pivot Table" > > Regards, > > Sergio > > 2009/4/23 gabo <gabo22...@yahoo.com> > >> >> I have a spreadsheet where I need to combine some rows into columns. >> Listed below is an example of the spreadsheet. >> >> Cust Id Name Item Qty >> >> 1 Joe table 1 >> 1 Joe Chair 2 >> 2 Sam table 1 >> 3 Steve lamp 1 >> 3 Steve table 1 >> >> Is there a way to make the above spreadsheet look like the one below >> where it can be used with a Word merge? >> >> Cust Id Name Table Chair Lamp >> >> 1 Joe 1 2 >> 2 Sam 1 >> 3 Steve 1 1 >> >> >> >> >> >> -- Thanks & Regards, Harmeet Singh --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
gabo(1).xls
Description: MS-Excel spreadsheet
