I recieve an automated report from a system that is not currently modifiable. I need to be able to rearrange the report by running a macro. The layout of the report is as follows:
name1 event1 accomplishdate1 expiredate1
name1 event2 accomplishdate2 expiredate2
name1 event3 accomplishdate3 expiredate3
name2 event1 accomplishdate1 expiredate1
name2 event2 accomplishdate2 expiredate2
name2 event3 accomplishdate3 expiredate3
and so on... (not always the same number of names, but the number of events are constant)
I need it to be the following:
NAME____EVENT1___EVENT2___EVENT3
______ acc | exp__acc | exp__acc | exp
name1
name2
name3
(ignore the underlines, they are just there for structure)
I hope this makes sense.
name1 event1 accomplishdate1 expiredate1
name1 event2 accomplishdate2 expiredate2
name1 event3 accomplishdate3 expiredate3
name2 event1 accomplishdate1 expiredate1
name2 event2 accomplishdate2 expiredate2
name2 event3 accomplishdate3 expiredate3
and so on... (not always the same number of names, but the number of events are constant)
I need it to be the following:
NAME____EVENT1___EVENT2___EVENT3
______ acc | exp__acc | exp__acc | exp
name1
name2
name3
(ignore the underlines, they are just there for structure)
I hope this makes sense.
Last edited: