Let me start this by saying this may be a simple problem but I did a bit of research (likely using improper terminology) and couldn't find anything.
I have a pricing sheet that lists prices per part number vertically rather than horizontally. There is also a space at the start of a price list so that it does not line up with the part number.
Example: Part# Price$
12345
$99.00
$87.00
$88.00
54321
38574
20094
$26.00
$28.00
$23.99
Where $99,$87,$88 correspond to A1 and $26,$28, and $23.99 correspond to A7.
Is there any way I can merge all of the prices to the first blank cell above them?
Example:
12345 $99.00, $87.00, $88.00
54321
38574
20094 $26.00, $28.00, $23.99
Bookmarks