Macro to convert Excel column to a row

[informationstation]

Hello

I have raw data in A1 through A309. I am looking to move this data in E1, but I have an additional 28 sheets to go through with entries as high as 1500 rows.

I also am looking for a solution to make sure that the raw data from A1 includes a quotation, as if the raw data has concatenate formula with it. I am concatenating data and putting quotations around the numbers.

So my D column appears as '20101' after the concatenation.
Additionally through my D column it is, '20101', '20201', '20210', etc... <<<< I need this format in a row, in a single cell E1, in the single E1 cell, formatted to the cell, in a row to the right.

I would like to have a macro that I can copy and paste into each excel spreadsheet so I can auto populate the concatenate into a single cell E1.

Thanks

[informationstation]

Looking for a quick response please

Transpose adds it correctly to the row, but I cannot merge the cell's or leave it as 1 cell. So I have 309 additional columns which does not work for this particular application.

[oeldere]

2 things.

You posted in the wrong sub (excel instead of Excel programming).

You get better help if you add a small example of your data.

Please also add the expected result in your file.