Automatically Populate Results Based on Inputs

[Marvinexcel]

Good Day Excel MVPs and Experts.

Please advise.

I want to automatically populate in any order the results in Table 1 based on data inputs table.
I also want to have a button to click for the results in table 1 to "repopulate" again and again.

Can anybody help me?

Thanks in advance.

DATA INPUTS:
apple	2	pear	2	orange	1
turnips	2	grapes	1	berry	2
papaya	1	avocado	1	pomegranate	1
lemon	1	mango	2	kiwi	1
pineapple	3	starapple	2	soursop	1

<colgroup><col><col span="3"><col><col></colgroup><tbody>
</tbody>

	Table 1
	A	B	C	D	E	F
1	apple	pear	apple		pear	orange
2		turnips	turnips	grapes	berry	berry
3		papaya		avocado		pomegranate
4	kiwi			mango	mango	lemon
5	pineapple	pineapple	soursop	pineapple	starapple	starapple

<colgroup><col><col span="2"><col><col><col><col></colgroup><tbody>
</tbody>