Hi Guys,
I need to change a multiple line excel sheet to the a single line sheet.
I have the below sheet
<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
and want it to be in this format
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
There will be over 100 lines in the multi line one
I need to change a multiple line excel sheet to the a single line sheet.
I have the below sheet
A | B | C | J | |
---|---|---|---|---|
1 | Exported On: 16/08/2019 15:40:57 | |||
2 | Employees.Forename | Employees.Surname | PaymentHistory.PaymentHrsNoCur | PaymentHistory.PaymentDescription |
3 | User | one | 45 | Basic Pay |
4 | User | one | 10.03 | Overtime |
5 | User | two | 38.5 | Basic Pay |
6 | User | three | 45 | Basic Pay |
7 | User | three | 10.25 | Overtime |
8 | User | Four | 45 | ARTIC RATE |
9 | User | Four | 9.03 | ARTIC OVERTIME |
10 | User | Five | 24 | Basic Pay |
11 | User | six | 24 | Basic Pay |
12 | User | Seven | 45 | Basic Pay |
13 | User | Seven | 4 | Overtime |
14 | User | Eight | 45 | ARTIC RATE |
15 | User | Nine | 43 | Basic Pay |
16 | User | Ten | 45 | Basic Pay |
17 | User | Ten | 2.12 | Overtime |
18 | User | Eleven | 44 | Basic Pay |
19 | User | Twelve | 44 | Basic Pay |
20 | User | Fourteen | 44 | Basic Pay |
21 | User | Fifteen | 45 | Basic Pay |
22 | User | Fifteen | 11.12 | Overtime |
23 | User | Sixteen | 45 | Basic Pay |
24 | User | Sixteen | 5.24 | Overtime |
25 | User | Sixteen | 5.53 | Time and a half |
<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Raw Data
and want it to be in this format
A | B | C | D | E | F | G | H | I | J | |
---|---|---|---|---|---|---|---|---|---|---|
1 | Employees.Forename | Employees.Surname | Basic Pay | Overtime | ARTIC RATE | ARTIC OVERTIME | Time and a half | CHARGEHAND | Salary | Total |
2 | User | one | ||||||||
3 | User | two | ||||||||
4 | User | three | ||||||||
5 | User | Four | ||||||||
6 | User | Five | ||||||||
7 | User | six | ||||||||
8 | User | Seven | ||||||||
9 | User | Eight | ||||||||
10 | User | Nine | ||||||||
11 | User | Ten | ||||||||
12 | User | Eleven | ||||||||
13 | User | Twelve | ||||||||
14 | User | Fourteen | ||||||||
15 | User | Fifteen | ||||||||
16 | User | Sixteen |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Single Line
How do i achieve this? There will be over 100 lines in the multi line one