Hello everyone,
I have the below dataset and I would like to display it in the format that I've highlighted below:Please suggest.
| ELEMENT_NAME | VALUE |
| PO Number | 4500018345 |
| Invoice Total Amount | 95000.00 |
| Invoice Number | 77777 |
| Supplier Name | ABC |
| Invoice Date | 20130610 |
| PO Line Number | 70 |
| Line Total Amount | 50000.00 |
| PO Line Number | 80 |
| Line Total Amount | 45000.00 |
| PO Number | 4500018376 |
| Invoice Total Amount | 60000.00 |
| Invoice Number | PurchRev1 |
| Supplier Name | CDF |
| Invoice Date | 20130820 |
| PO Line Number | 10 |
| Line Total Amount | 60000.00 |
Required format:
| Invoice Number | PO Number | Invoice Total Amount | Supplier Name | Invoice Date | PO Line Number | Line Total Amount |
| 77777 | 4500018345 | 95000.00 | ABC | 20130610 | 70 | 50000.00 |
| 77777 | 4500018345 | 95000.00 | ABC | 20130610 | 80 | 45000.00 |
| PurchRev1 | 4500018376 | 60000.00 | CDF | 20130820 | 10 | 60000.00 |