seven1four
New Member
- Joined
- Jan 18, 2019
- Messages
- 7
Hello,
I got two set of data that needs to be align by id. I need a formula/vba to go down two sets of number and insert a blank line if there's no match and go on to the next number. One set of data is a-d and the other is f-i. I was only able to find something that only insert blanks into 1 side not the other. Both list contain around 400 rows.
Thank you.
Windows 7
Office Pro 2010
Raw
[TABLE="width: 500"]
<tbody>[TR]
[TD]id[/TD]
[TD]name[/TD]
[TD]desscription[/TD]
[TD]$[/TD]
[TD][/TD]
[TD]id[/TD]
[TD]name[/TD]
[TD]description[/TD]
[TD]spent[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]joe[/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]albert[/TD]
[TD][/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]125[/TD]
[TD]lisa[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD]125[/TD]
[TD]lisa[/TD]
[TD][/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]125[/TD]
[TD]lisa[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD]150[/TD]
[TD]anne[/TD]
[TD][/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]126[/TD]
[TD]mike[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
After
[TABLE="width: 500"]
<tbody>[TR]
[TD]id[/TD]
[TD]name[/TD]
[TD]description[/TD]
[TD]spent[/TD]
[TD][/TD]
[TD]id[/TD]
[TD]name[/TD]
[TD]description[/TD]
[TD]spent[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD]albert[/TD]
[TD][/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]joe[/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]125[/TD]
[TD]lisa[/TD]
[TD][/TD]
[TD]4[/TD]
[TD][/TD]
[TD]125[/TD]
[TD]lisa[/TD]
[TD][/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]125[/TD]
[TD]lisa[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]126[/TD]
[TD]mike[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]150[/TD]
[TD]anne[/TD]
[TD][/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]
I got two set of data that needs to be align by id. I need a formula/vba to go down two sets of number and insert a blank line if there's no match and go on to the next number. One set of data is a-d and the other is f-i. I was only able to find something that only insert blanks into 1 side not the other. Both list contain around 400 rows.
Thank you.
Windows 7
Office Pro 2010
Raw
[TABLE="width: 500"]
<tbody>[TR]
[TD]id[/TD]
[TD]name[/TD]
[TD]desscription[/TD]
[TD]$[/TD]
[TD][/TD]
[TD]id[/TD]
[TD]name[/TD]
[TD]description[/TD]
[TD]spent[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]joe[/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]albert[/TD]
[TD][/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]125[/TD]
[TD]lisa[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD]125[/TD]
[TD]lisa[/TD]
[TD][/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]125[/TD]
[TD]lisa[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD]150[/TD]
[TD]anne[/TD]
[TD][/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]126[/TD]
[TD]mike[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
After
[TABLE="width: 500"]
<tbody>[TR]
[TD]id[/TD]
[TD]name[/TD]
[TD]description[/TD]
[TD]spent[/TD]
[TD][/TD]
[TD]id[/TD]
[TD]name[/TD]
[TD]description[/TD]
[TD]spent[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD]albert[/TD]
[TD][/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]joe[/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]125[/TD]
[TD]lisa[/TD]
[TD][/TD]
[TD]4[/TD]
[TD][/TD]
[TD]125[/TD]
[TD]lisa[/TD]
[TD][/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]125[/TD]
[TD]lisa[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]126[/TD]
[TD]mike[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]150[/TD]
[TD]anne[/TD]
[TD][/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]