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.

User	Item	Price	Item	Price
Bob	Apple	2	Orange	1
Bill			Orange	1
Michael	Apple	2

<tbody>
</tbody>

User	Item	Price	Item	Price
Bob	Apple	2	Orange	1
Bill	Orange	1
Michael	Apple	2

<tbody>
</tbody>

 

[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