Repeat rows based on cell values and populate new cell values, then copy

Hi,
I find this forum extremely helpful Was trying to look for a macro(if any) to help with my current issue, wondering if anyone has some tips, please.

Price Unique
A01 APPLE
B01 BATER
B02 BATER
C01 CATER
C02 CATER
C03 CATER


Price List (repeat the rows according to the column first price list)

Unique Col1 Col2 Col3 Col4 Col5 Col6
APPLE A B C D E F
BATER A B C D E F
BATER G H I J K L
BATER M N O P Q R
CATER A B C D E F
CATER M N O P Q R

Desired Results
APPLE A B C D E F A01
BATER A B C D E F B01
BATER G H I J K L B01
BATER M N O P Q R B01
BATER A B C D E F B02
BATER G H I J K L B02
BATER M N O P Q R B02
CATER A B C D E F C02
CATER M N O P Q R C02
CATER A B C D E F C03
CATER M N O P Q R C03