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

<tbody>
[TD="width: 62, bgcolor: transparent"] 22120
[/TD]
[TD="width: 70, bgcolor: transparent"] 2/2/2018
[/TD]
[TD="width: 62, bgcolor: transparent"] 22121
[/TD]
[TD="width: 70, bgcolor: transparent"] 2/3/2018
[/TD]
[TD="width: 62, bgcolor: transparent"] 22222
[/TD]
[TD="width: 70, bgcolor: transparent"] 2/4/2018
[/TD]
[TD="width: 62, bgcolor: transparent"] 22221
[/TD]
[TD="width: 70, bgcolor: transparent"] 2/5/2018
[/TD]
[TD="width: 62, bgcolor: transparent"] 22220
[/TD]

</tbody>

I need the data to appearthis way:

Date Proc

2/1/2018

<tbody>
[TD="width: 138, bgcolor: transparent"] 22120
[/TD]

[TD="width: 149, bgcolor: transparent"] 2/2/2018
[/TD]
[TD="width: 138, bgcolor: transparent"] 22121
[/TD]

[TD="width: 149, bgcolor: transparent"] 2/3/2018
[/TD]
[TD="width: 138, bgcolor: transparent"] 22222
[/TD]

[TD="width: 149, bgcolor: transparent"] 2/4/2018
[/TD]
[TD="width: 138, bgcolor: transparent"] 22221
[/TD]

</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.