Convert data to vertical format and insert rows

[stylencia18]

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

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!!

 

[stylencia18]

Ah, I see. Sorry - data was in sheet 1. It worked but messed up the rest of the data in my original sheet. I have 20 columns of data.

 

[stylencia18]

So it worked but the rest of the data in my spreadsheet is messed up. I have 20 columns of data.

 

[mumps]

I think that it would be easier to help and test possible solutions if I could work with your actual file which includes any macros you are currently using. Perhaps you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.