Changing Multiple Lines to Single Lines

[SeamusBo]

Hi Guys,
I need to change a multiple line excel sheet to the a single line sheet.

I have the below sheet

	A	B	C	J
Exported On: 16/08/2019 15:40:57
User	one	Basic Pay
User	one	Overtime
User	two	Basic Pay
User	three	Basic Pay
User	three	Overtime
User	Four	ARTIC RATE
User	Four	ARTIC OVERTIME
User	Five	Basic Pay
User	six	Basic Pay
User	Seven	Basic Pay
User	Seven	Overtime
User	Eight	ARTIC RATE
User	Nine	Basic Pay
User	Ten	Basic Pay
User	Ten	Overtime
User	Eleven	Basic Pay
User	Twelve	Basic Pay
User	Fourteen	Basic Pay
User	Fifteen	Basic Pay
User	Fifteen	Overtime
User	Sixteen	Basic Pay
User	Sixteen	Overtime
User	Sixteen	Time and a half

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=00DC00]#00DC00[/URL] "]Employees.Forename[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=00DC00]#00DC00[/URL] "]Employees.Surname[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=00DC00]#00DC00[/URL] , align: center"]PaymentHistory.PaymentHrsNoCur[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=00DC00]#00DC00[/URL] "]PaymentHistory.PaymentDescription[/TD]

[TD="align: center"]3[/TD]

[TD="align: center"]45[/TD]

[TD="align: center"]4[/TD]

[TD="align: center"]10.03[/TD]

[TD="align: center"]5[/TD]

[TD="align: center"]38.5[/TD]

[TD="align: center"]6[/TD]

[TD="align: center"]45[/TD]

[TD="align: center"]7[/TD]

[TD="align: center"]10.25[/TD]

[TD="align: center"]8[/TD]

[TD="align: center"]45[/TD]

[TD="align: center"]9[/TD]

[TD="align: center"]9.03[/TD]

[TD="align: center"]10[/TD]

[TD="align: center"]24[/TD]

[TD="align: center"]11[/TD]

[TD="align: center"]24[/TD]

[TD="align: center"]12[/TD]

[TD="align: center"]45[/TD]

[TD="align: center"]13[/TD]

[TD="align: center"]4[/TD]

[TD="align: center"]14[/TD]

[TD="align: center"]45[/TD]

[TD="align: center"]15[/TD]

[TD="align: center"]43[/TD]

[TD="align: center"]16[/TD]

[TD="align: center"]45[/TD]

[TD="align: center"]17[/TD]

[TD="align: center"]2.12[/TD]

[TD="align: center"]18[/TD]

[TD="align: center"]44[/TD]

[TD="align: center"]19[/TD]

[TD="align: center"]44[/TD]

[TD="align: center"]20[/TD]

[TD="align: center"]44[/TD]

[TD="align: center"]21[/TD]

[TD="align: center"]45[/TD]

[TD="align: center"]22[/TD]

[TD="align: center"]11.12[/TD]

[TD="align: center"]23[/TD]

[TD="align: center"]45[/TD]

[TD="align: center"]24[/TD]

[TD="align: center"]5.24[/TD]

[TD="align: center"]25[/TD]

[TD="align: center"]5.53[/TD]

</tbody>

Raw Data​

and want it to be in this format

	A	B	C	D	E	F	G	H	I	J
User	one
User	two
User	three
User	Four
User	Five
User	six
User	Seven
User	Eight
User	Nine
User	Ten
User	Eleven
User	Twelve
User	Fourteen
User	Fifteen
User	Sixteen

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="bgcolor: #FFFF00"]Employees.Forename[/TD]
[TD="bgcolor: #FFFF00"]Employees.Surname[/TD]
[TD="bgcolor: #FFFF00"]Basic Pay[/TD]
[TD="bgcolor: #FFFF00"]Overtime[/TD]
[TD="bgcolor: #FFFF00"]ARTIC RATE[/TD]
[TD="bgcolor: #FFFF00"]ARTIC OVERTIME[/TD]
[TD="bgcolor: #FFFF00"]Time and a half[/TD]
[TD="bgcolor: #FFFF00"]CHARGEHAND[/TD]
[TD="bgcolor: #FFFF00"]Salary[/TD]
[TD="bgcolor: #FFFF00"]Total[/TD]

[TD="align: center"]2[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]8[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]11[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]12[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]13[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]14[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]15[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]16[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Single Line​

How do i achieve this?
There will be over 100 lines in the multi line one

 

[jasonb75]

As this appears to be a duplicate thread, I've asked for it to be locked.
Original thread https://www.mrexcel.com/forum/excel-questions/1109589-changing-multiple-line-single-line.html

 

[SeamusBo]

i have asked for the other thread to be closed as i couldn't get the screen shots to load.

 

[Fluff]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you ask for a thread to be deleted please wait for that to happen before starting a new thread.
Thanks