stylencia18
New Member
- Joined
- Aug 14, 2017
- Messages
- 31
Good morning:
I have thousands of rows of datain the following format:
Date 1 Proc 1 Date 2 Proc 2 Date 3 Proc 3 Date 4 Proc 4 Date 5 Proc 5
<tbody>
</tbody>
I need the data to appearthis way:
Date Proc
<tbody>
</tbody>
Can someone please help me?!I’ve tried the Transpose option but it doesn’t work.
Thank you!!
I have thousands of rows of datain the following format:
Date 1 Proc 1 Date 2 Proc 2 Date 3 Proc 3 Date 4 Proc 4 Date 5 Proc 5
2/1/2018 | 22120 | 2/2/2018 | 22121 | 2/3/2018 | 22222 | 2/4/2018 | 22221 | 2/5/2018 | 22220 |
<tbody>
</tbody>
I need the data to appearthis way:
Date Proc
2/1/2018 | 22120 |
2/2/2018 | 22121 |
2/3/2018 | 22222 |
2/4/2018 | 22221 |
<tbody>
</tbody>
Can someone please help me?!I’ve tried the Transpose option but it doesn’t work.
Thank you!!