I have a set of data similar to below. I want to move the last two variables down underneath ID1 and Description1 and retain the first variable. Have Date Name ID1 Description1 ID2 Description2 29-Apr-17 Claire 123 100 . 04-Apr-17 David 456 200 555 300 05-Apr-17 David 456 200 555 300 06-Apr-17 David 456 200 555 300 06-Apr-17 David 456 200 555 300 24-Apr-17 David 456 200 555 300 25-Apr-17 David 456 200 555 300 25-Apr-17 David 456 200 555 300 26-Apr-17 David 456 200 555 300 26-Apr-17 David 456 200 555 300 27-Apr-17 David 456 200 555 300 Want: Date Name ID1 Description1 29-Apr-17 Claire 123 100 04-Apr-17 David 456 200 05-Apr-17 David 456 200 06-Apr-17 David 456 200 06-Apr-17 David 456 200 24-Apr-17 David 456 200 25-Apr-17 David 456 200 25-Apr-17 David 456 200 26-Apr-17 David 456 200 26-Apr-17 David 456 200 27-Apr-17 David 456 200 04-Apr-17 David 555 300 05-Apr-17 David 555 300 06-Apr-17 David 555 300 06-Apr-17 David 555 300 24-Apr-17 David 555 300 25-Apr-17 David 555 300 25-Apr-17 David 555 300 26-Apr-17 David 555 300 26-Apr-17 David 555 300 27-Apr-17 David 555 300 Thanks in advance.
... View more