onthecauseway
New Member
- Joined
- Oct 19, 2017
- Messages
- 2
I have a spreadsheet to track documents issued, when and a transmittal number. The transmittal can have multiple documents and each document can have multiple revisions.
Where I am stuck is trying to format this data into a report based on documents or on transmittal. I have tried using a pivot table but this doesnt give the correct format, for example I want the doc number & title on the same line. Below shows what I am after.
Is Pivot tables the way to go and if so how do i control the formatting?
<tbody>
</tbody>
<tbody>
</tbody>
Where I am stuck is trying to format this data into a report based on documents or on transmittal. I have tried using a pivot table but this doesnt give the correct format, for example I want the doc number & title on the same line. Below shows what I am after.
Is Pivot tables the way to go and if so how do i control the formatting?
<tbody> </tbody> | ||||||||||||||||||||||||||||||||||||||||||||
<tbody>
</tbody>
REPORT BY TRANSMITTAL | |||
12345-PL-CL-TM-001 | 01/10/2019 | ||
12345-DC-00-001 | A | 1ST FLOOR PLAN | |
12345-dc-00-002 | A | FIRST FLOOR SECTION | |
12345-PL-CL-TM-002 | 02/10/2019 | ||
12345-DC-00-001 | B | 1ST FLOOR PLAN | |
12345-dc-00-003 | A | NORTH ELEVATION | |
12345-PL-CL-TM-003 | 03/10/2019 | ||
12345-dc-00-004 | A | BUIDING EAST ELEVATION | |
12345-PL-CL-TM-004 | 04/10/2019 | ||
12345-DC-00-001 | C | 1ST FLOOR PLAN |
<tbody>
</tbody>