Shifting Cells or something similar

[kenny_cohen]

OK, so this might be a weird question, I'm not sure it is doable through a formula, possibly a macro but I'm curious to see your opinions. So I have a list of users, items and prices, but for some users they didn't buy an item. So on the next sheet I just want a list that goes through what they bought. So the first table is the like the sheet I have and the second table is what I want the new sheet to read.

[TABLE="width: 500"]
<tbody>[TR]
[TD]User[/TD]
[TD]Item[/TD]
[TD]Price[/TD]
[TD]Item[/TD]
[TD]Price[/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD]Apple[/TD]
[TD]2[/TD]
[TD]Orange[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Bill[/TD]
[TD][/TD]
[TD][/TD]
[TD]Orange[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Michael[/TD]
[TD]Apple[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 500"]
<tbody>[TR]
[TD]User[/TD]
[TD]Item[/TD]
[TD]Price[/TD]
[TD]Item[/TD]
[TD]Price[/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD]Apple[/TD]
[TD]2[/TD]
[TD]Orange[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Bill[/TD]
[TD]Orange[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Michael[/TD]
[TD]Apple[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[liveinhope]

This solution is only practical if the list is short

- on the "Bill" row select the 2 blank cells next to the word "Bill"
- right click
- select delete then "shift left"


Otherwise you will need a macro