Changing Multiple Lines to Single Lines

Status
Not open for further replies.

SeamusBo

New Member
Joined
Sep 12, 2019
Messages
6
Hi Guys,
I need to change a multiple line excel sheet to the a single line sheet.

I have the below sheet
ABCJ
1Exported On: 16/08/2019 15:40:57
2Employees.ForenameEmployees.SurnamePaymentHistory.PaymentHrsNoCurPaymentHistory.PaymentDescription
3Userone45Basic Pay
4Userone10.03Overtime
5Usertwo38.5Basic Pay
6Userthree45Basic Pay
7Userthree10.25Overtime
8UserFour45ARTIC RATE
9UserFour9.03ARTIC OVERTIME
10UserFive24Basic Pay
11Usersix24Basic Pay
12UserSeven45Basic Pay
13UserSeven4Overtime
14UserEight45ARTIC RATE
15UserNine43Basic Pay
16UserTen45Basic Pay
17UserTen2.12Overtime
18UserEleven44Basic Pay
19UserTwelve44Basic Pay
20UserFourteen44Basic Pay
21UserFifteen45Basic Pay
22UserFifteen11.12Overtime
23UserSixteen45Basic Pay
24UserSixteen5.24Overtime
25UserSixteen5.53Time 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
ABCDEFGHIJ
1Employees.ForenameEmployees.SurnameBasic PayOvertimeARTIC RATEARTIC OVERTIMETime and a halfCHARGEHANDSalaryTotal
2Userone
3Usertwo
4Userthree
5UserFour
6UserFive
7Usersix
8UserSeven
9UserEight
10UserNine
11UserTen
12UserEleven
13UserTwelve
14UserFourteen
15UserFifteen
16UserSixteen

<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
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
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
 
Upvote 0
Status
Not open for further replies.

Forum statistics

Threads
1,213,567
Messages
6,114,344
Members
448,570
Latest member
rik81h

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top