Transform Single Column to Range

[agentx95]

Hi, can anyone help me how to do this. So I have this single column that I want to convert to range by using the blank as the point where excel will start another row. Thanks everyone.

[Saqib Qureshi]

This can be achieved with VBA if you have huge data. However, for few entries you can use Paste-Transpose to do the work.

[agentx95]

I have huge data on the single column. Help pls.

[torachan]

Transpose often 'falls over' if you have 5,460 - 8,190 maximum rows of data.
As the data string is variable (i.e. 7 or 10 cells long) it would be more useful to have an example of say 100 rows of actual data to appreciate the pattern.
The more information we have the more likely you are going to get a successful answer first time.
torachan.

[agentx95]

Im sorry. Im new here. Here is a sample scenario of data. Ive been trying to figure this out for days.

[Saqib Qureshi]

Use this Code in Module

Please Login or Register  to view this content.