If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
consolidating data for a report - HELP - pivot tables no good for
Hi
The spreadsheet shows people on up to 20 differant projects with each project have 2 colums of data i.e. BY and BZ. My example cuts it down to 4 columns and 7 rows as below i.e. A | B | BY | BZ Project Name Fred Rate 400 B 1 400 S 0.5 200 X 0 L1 0.5 200 Therefore each staff name has 5 rows containing data, note this is only a partial view of all data. the data needs to be reported in the following heading and data format Project Name | Name | Rate | B | S | X | L1 proj A Fred 400 1 0.5 0 0.5 I need to be able to select the project name i.e. proj A (in a cell) to genterate the report. Any ideas please and many thanks in advance. regards UKMAN1 |
Thread Tools | |
Display Modes | |
|
|