danhendo888
Board Regular
- Joined
- Jul 15, 2019
- Messages
- 167
- Office Version
- 365
- Platform
- Windows
| Book1 | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | |||
| 1 | INV | |||||||||
| 2 | 268385 | |||||||||
| 3 | 29-May-19 | |||||||||
| 4 | JOB: T00009719 | |||||||||
| 5 | 28-Jun-19 | |||||||||
| 6 | 1,394.52 | |||||||||
| 7 | 1,394.52 | |||||||||
| 8 | 1,394.52 | |||||||||
| 9 | INV | |||||||||
| 10 | 268466 | |||||||||
| 11 | 29-May-19 | |||||||||
| 12 | JOB: T00009709 | |||||||||
| 13 | 28-Jun-19 | |||||||||
| 14 | 1,947.08 | |||||||||
| 15 | 1,947.08 | |||||||||
| 16 | 3,341.60 | |||||||||
| 17 | ||||||||||
| 18 | INV | 268385 | 29-May-19 | JOB: T00009719 | 28-Jun-19 | 1,394.52 | 1,394.52 | 1,394.52 | ||
| 19 | INV | 268466 | 29-May-19 | JOB: T00009709 | 28-Jun-19 | 1,947.08 | 1,947.08 | 3,341.60 | ||
Sheet1 | ||||||||||
Need to get the column into desired output.
FWIW It doesn't matter how many rows in between the data in the desired output.
As long as I can get one invoices details into one row, I am happy.
How best can I get about this?
