VBA code to paste value on row column A with all value on Column B

[kevs83s]

Please i need help! i want to take the unique value of Row A2 and get all the Value of row B and C paste on a different cell. Please see the example below of what i am trying to do. Thank you for you help

bill	item	Price			bill	item	price
123	abc	10			123	abc	10
456	bca	4			123	bca	4
789	cab	6			123	cab	6
					456	abc	10
					456	bca	4
					456	cab	6
					789	abc	10
					789	bca	4
					789	cab	10

<tbody>
</tbody>

 

[wist]

you can use a vlookup formula and two helper columns to achieve this. Check this link. The second scenario describes the formula
https://www.extendoffice.com/documents/excel/1897-excel-repeat-cell-value-x-times.html