anyone have know how to convert the following source data that looks like this:

5105473, 5105474, 5105475 batch 12/21/2012 187836




where 5105473, 5105474, 5105475 is in column A, batch is in column B, 12/21/2012 is in column C and 187836 is in column D


goal is to return 3 rows and 4 columns that look like this:

5105473 batch 12/21/2012 187836
5105474 batch 12/21/2012 187836
5105475 batch 12/21/2012 187836

needs to be dynamic, values in column A can vary 2-20 values
total number of rows can also vary

thanks in advance