StillLearning123
New Member
- Joined
- Sep 26, 2013
- Messages
- 1
I am using Windows 7 Professional and Microsoft Excel 2010. This is my first post, please bear with me and make suggestions on where I can improve.
In short, I am trying to find the most efficient way to pull an 'Item Description' that is in the first row of invoice details whereby I would like it to follow each line item detail to summarize using a Pivot Table. Format of the data is the first two rows below, followed by an example whereby I would like the 'Item Desc' to follow each 'Ext. P'
<tbody>
</tbody>
In short, I am trying to find the most efficient way to pull an 'Item Description' that is in the first row of invoice details whereby I would like it to follow each line item detail to summarize using a Pivot Table. Format of the data is the first two rows below, followed by an example whereby I would like the 'Item Desc' to follow each 'Ext. P'
Item Number | Item Desc. | ||||||||
Inv # | Date | Cust. ID | Q | UP | Ext. P | ||||
B123 | Client 123 | ||||||||
01 | 09/26/2013 | WM01 | 1 | 5 | 5 | INSERT 'Client 123' here | |||
<tbody>
</tbody>