My vb skills are beginner. I can follow, but don't know enough to write my own code.

I have a lot of recipes with ingredient data by the amount, measure type, and ingredient name, plus other cooking related data, in columns. The ingredient data is separated by grouping of three headings: item1amt, item1qty, item1 to a maximum of item28amt, item28qty, item28. This created a lot of columns. This style worked for a spreadsheet, but now I'm creating a database and this won't work.

I found examples of transposing from col to row. But need something more complex.

Example of the current format, each item is in a separate column, in the same row.
Brownies ¾ cup butter 4 ounces chocolate 2 cups sugar 3 each eggs 1 teaspoon vanilla 1 cup flour 1 cup almonds


I'd like the code to loop, due to some recipes with a few ingredients, and others with a lot. There is other information, that remains as is. The changes begin with column 'R', and end with column CU. I have a total of 1721 rows.

My goal is to to move the ingredient related data from columns to rows. Separating data into three new columns, while creating as many new rows as ingredients. Creating a new table of data on a new tab.

Move the data from current columns to new columns:
Old heading name item(*)amt to new heading name amount
Old heading item(*)qty to new heading name measure
Old heading item(*) to new heading name ingredient

With the 'A' column repeating the recipe name for each of the new rows, for each separate recipe. If possible I'd like to run this on the entire spreadsheet.

Recipe Name Amount Measure Ingredient
Brownies ¾ cup butter
Brownies 4 ounces chocolate
Brownies 2 cups sugar
Brownies 3 each eggs
Brownies 1 teaspoon vanilla
Brownies 1 cup flour
Brownies 1 cup almonds

Thanks in advance.