Copy and Paste with Transpose function

Hello, I have a situation where i need to reorganize the data that comes in one column to a table with multiple columns. I tried using transpose function but it takes an enormous amount of time due to a huge amount of source data. Here is the example. I'm sure there is an easier way to reorganize the data in the columns, but I haven't been able to come up with it yet. I'd appreciate any advise. Thanks!

image.png

A picture is not much use to us, and we can't see which rows and columns you are using. It would be more helpful if you attached a sample Excel workbook, as detailed in the yellow banner near the top of the screen.

Also, please confirm the version of Excel that you are currently using, and update your profile on User CP to show this if it has changed since your first joined ten years ago.

Hope this helps.

Pete

[QUOTE=TMS;5958253]If you have upgraded to Excel 365, then:

Formula:

Please Login or Register  to view this content.

With headings:

Formula:

Please Login or Register  to view this content.

[/QUOTE

You are a life saver!!! Thank you so much!