Excel Spreadsheet with grouped data

Some tips for the use of DataSlave

Moderators: Tom, ian

Excel Spreadsheet with grouped data

Postby ian » Sat Oct 08, 2011 10:52 am

Barry asked how to handle excel data where the data is grouped. In the attached example a spreadsheet has the monthly sales data shown for each region. The sample map shows how to create a single output with a column indicating the region and the sales figures for all regions.

The example is rather simple, but illustrates the technique.
Attachments
Excel_Data_Group.zip
(222.79 KiB) Downloaded 535 times
ian
 
Posts: 364
Joined: Sat Dec 18, 2004 8:13 am
Location: UK

Return to Tips

Who is online

Users browsing this forum: No registered users and 1 guest

cron