I'm trying to combine files in PQ that have an extra row above the headers.
How would I combine these files by deleting Row1 and promoting Row2 as headers?
<tbody>
</tbody>
<tbody>
</tbody>
How would I combine these files by deleting Row1 and promoting Row2 as headers?
Count | 5 | |
ID | Action | Date |
11111 | INP | 18-Oct |
22222 | INP | 19-Oct |
33333 | INP | 20-Oct |
44444 | CLOSED | 21-Oct |
55555 | INP | 22-Oct |
<tbody>
</tbody>
Count | 3 | |
ID | Action | Date |
66666 | CLOSED | 18-Oct |
77777 | INP | 19-Oct |
88888 | INP | 20-Oct |
<tbody>
</tbody>