LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
RJB RJB is offline
external usenet poster
 
Posts: 86
Default Break a table into discrete info

I have a table with

A5:A235 is a list of employees
B4:AF4 is days in a month
B5:AF235 is populated with hours worked over the month.

My client would like this in list form.

In other words,

Employee 1, Day 1, Hours
Employee 1, Day 2, Hours
..
..
..
Employee 1, Day 31, Hours
Employee 2, Day 1, Hours
Employee 2, Day 2, Hours
..
..
..
Employee N, Day 31, Hours


Explain how to please.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Making a list of discrete numbers (names?) and occurences of each partsman_ba New Users to Excel 10 August 22nd 09 03:02 PM
Count Number of Discrete Cells, Based on Another Column RJB Excel Discussion (Misc queries) 8 June 4th 08 05:22 AM
How do I sum cells by refering to discrete values? Jive Excel Worksheet Functions 7 June 6th 07 10:28 AM
How do I create a historgram of non-discrete events mg Charts and Charting in Excel 2 October 16th 06 05:54 PM
Pivot Table Page Break problem Patricia D Excel Discussion (Misc queries) 0 February 6th 06 11:56 PM


All times are GMT +1. The time now is 12:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"