Rows for each column

Question

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                       PriceItem7/10/20217/17/20217/24/20217/31/2021      $15.99ITEM F69  3      $15.99ITEM G3954 99      $17.99ITEM F 5        $18.99ITEM E 33 40      $19.99ITEM A59976040      $19.99ITEM B52  46      $21.99ITEM B 40 55      $21.99ITEM C  131      $21.99ITEM D          $32.99ITEM A  8816      $49.99ITEM H                                              output                       7/10/20217/10/20217/10/20217/17/20217/17/20217/17/20217/24/20217/24/20217/24/20217/31/20217/31/20217/31/2021PriceItemUnitsPriceItemUnitsPriceItemUnitsPriceItemUnits$15.99ITEM F69$15.99ITEM G54$19.99ITEM A60$15.99ITEM F3$15.99ITEM G39$17.99ITEM F5$21.99ITEM C13$18.99ITEM G99$19.99ITEM A59$18.99ITEM E33$32.99ITEM A88$18.99ITEM E40$19.99ITEM B52$19.99ITEM A97   $19.99ITEM A40   $21.99ITEM B40   $19.99ITEM B46         $21.99ITEM B55         $21.99ITEM C1         $32.99ITEM A16

input-output example.xlsx

binu_acs · Accepted Answer

@brent_excel One way of doing this