Excel Macro to rearrange data fields
- or -
Post a project like this2000
$50
- Posted:
- Proposals: 1
- Remote
- #2182907
- Awarded
Description
Experience Level: Entry
I extract Golf Tee Time data and paste it into excel - This is what it looks like in column A (Each item is on a different line)
6:30 AM
Not Available
Bob Green
Guest
Guest
Guest
Tee
1
6:30 AM
Available
4
QUICK BOOK
Tee
10
6:38 AM
Not Available
Darren Jacobs
Paul MacGregor
Chris Smith
Paul Owen
Tee
1
6:38 AM
Available
2
John Jones
Guest
Tee
10
I need to run a Macro to change the format of the data:
It can move it into the same worksheet or into a different TAB
Column B (TIME) Column C (PLAYER) Column D (TEE)
6:30 AM Bob Green 1
6:30 AM Guest 1
6:30 AM Guest 1
6:30 AM Guest 1
6:30 AM Available 10
6:30 AM Available 10
6:30 AM Available 10
6:30 AM Available 10
6:38 AM Darren Jacobs 1
6:38 AM Paul MacGregor 1
6:38 AM Chris Smith 1
6:38 AM Paul Owen 1
6:38 AM John Jones 10
6:38 AM Guest 10
6:38 AM Available 10
6:38 AM Available 10
Let me know if you have any questions?
6:30 AM
Not Available
Bob Green
Guest
Guest
Guest
Tee
1
6:30 AM
Available
4
QUICK BOOK
Tee
10
6:38 AM
Not Available
Darren Jacobs
Paul MacGregor
Chris Smith
Paul Owen
Tee
1
6:38 AM
Available
2
John Jones
Guest
Tee
10
I need to run a Macro to change the format of the data:
It can move it into the same worksheet or into a different TAB
Column B (TIME) Column C (PLAYER) Column D (TEE)
6:30 AM Bob Green 1
6:30 AM Guest 1
6:30 AM Guest 1
6:30 AM Guest 1
6:30 AM Available 10
6:30 AM Available 10
6:30 AM Available 10
6:30 AM Available 10
6:38 AM Darren Jacobs 1
6:38 AM Paul MacGregor 1
6:38 AM Chris Smith 1
6:38 AM Paul Owen 1
6:38 AM John Jones 10
6:38 AM Guest 10
6:38 AM Available 10
6:38 AM Available 10
Let me know if you have any questions?
Dave M.
100% (3)Projects Completed
4
Freelancers worked with
3
Projects awarded
100%
Last project
30 Nov 2022
South Africa
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies