Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining multiple data records
I receive daily production reports for the manufacturing of our products that
have to go through 3 manufacturing stations. I enter the information into a spreadsheet in the following format. The 'X' indicates that the part number went through the manufacturing station on that day. Date Part # Stn A Stn B Stn C 6/23 10506 X 6/23 10602 X X 6/23 20506 X 6/23 30904 X 6/24 10506 X X 6/24 10602 X 6/24 30904 X 6/24 10805 X etc.... I would like to summarize the data on a separate worksheet as follows: Part # Stn A Stn B Stn C 10506 6/23 6/24 6/24 10602 6/23 6/23 6/24 20506 6/23 30904 6/23 6/24 10805 6/24 etc.... How can this summary table be created? Can it change dynamically as more data is added to the daily table? TIA David |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combining rows of data to make complete records | Excel Discussion (Misc queries) | |||
Combining Data from Multiple Columns | Excel Worksheet Functions | |||
Combining Data multiple tabs | Excel Discussion (Misc queries) | |||
Combining data from multiple sheets | Excel Discussion (Misc queries) | |||
combining data from multiple sheets | Excel Worksheet Functions |