Hello -
I'm wondering if someone knows how to take the take this input to create the following output:
Basically for each date in the columns, I would like to show the price, item and units
| input | |||||||||||
| Price | Item | 7/10/2021 | 7/17/2021 | 7/24/2021 | 7/31/2021 | ||||||
| $15.99 | ITEM F | 69 | 3 | ||||||||
| $15.99 | ITEM G | 39 | 54 | 99 | |||||||
| $17.99 | ITEM F | 5 | |||||||||
| $18.99 | ITEM E | 33 | 40 | ||||||||
| $19.99 | ITEM A | 59 | 97 | 60 | 40 | ||||||
| $19.99 | ITEM B | 52 | 46 | ||||||||
| $21.99 | ITEM B | 40 | 55 | ||||||||
| $21.99 | ITEM C | 13 | 1 | ||||||||
| $21.99 | ITEM D | ||||||||||
| $32.99 | ITEM A | 88 | 16 | ||||||||
| $49.99 | ITEM H | ||||||||||
| output | |||||||||||
| 7/10/2021 | 7/10/2021 | 7/10/2021 | 7/17/2021 | 7/17/2021 | 7/17/2021 | 7/24/2021 | 7/24/2021 | 7/24/2021 | 7/31/2021 | 7/31/2021 | 7/31/2021 |
| Price | Item | Units | Price | Item | Units | Price | Item | Units | Price | Item | Units |
| $15.99 | ITEM F | 69 | $15.99 | ITEM G | 54 | $19.99 | ITEM A | 60 | $15.99 | ITEM F | 3 |
| $15.99 | ITEM G | 39 | $17.99 | ITEM F | 5 | $21.99 | ITEM C | 13 | $18.99 | ITEM G | 99 |
| $19.99 | ITEM A | 59 | $18.99 | ITEM E | 33 | $32.99 | ITEM A | 88 | $18.99 | ITEM E | 40 |
| $19.99 | ITEM B | 52 | $19.99 | ITEM A | 97 | $19.99 | ITEM A | 40 | |||
| $21.99 | ITEM B | 40 | $19.99 | ITEM B | 46 | ||||||
| $21.99 | ITEM B | 55 | |||||||||
| $21.99 | ITEM C | 1 | |||||||||
| $32.99 | ITEM A | 16 |
Solved! Go to Solution.
