Multiple formula rows from single row of data, repeated for each row of data

Welcome to the forum.
You can use INDIRECT coupled with ROW to generate a row number which goes 2,2,2,2,3,3,3,3,4,4,...etc
For example, put these in B2 and C2 of your 'Output' sheet:

Formula:

Please Login or Register  to view this content.

The formula works by looking at the row number, subtracting 1 because we're starting on row 2, dividing that by 4 as you want to repeat the result four times, then rounding the result up, then finally adding 1 again because we want to start on row 2 for the answer as well. This is then put into the Indirect formula which converts into a cell reference using information in quotation marks and/or from a formula.
For example, in Output!B3, this is what happens:
ROW() = 3
ROW()-1 = 2
(ROW()-1)/4 = 0.5
ROUNDUP((ROW()-1)/4,0) = 1
ROUNDUP((ROW()-1)/4,0)+1 = 2
INDIRECT("Data!B$"&ROUNDUP((ROW()-1)/4,0)+1) = INDIRECT("Data!B$"&2) = Data!B$2 = Bill

I haven't done column A for you, as I suspect these examples were only to illustrate your question.

Hope that's of some help.

You're welcome.