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.