Transpose data to columns from rows keeping unique data together

[aimeecrystalaid]

So basically i have one single column with groups of information in it, each bit of info is separated by a space (1 row). I need a macro to move this info into 3 columns, keeping the matching information together in a row...

have attached an example of what i mean since i probably make no sense

thanks!Macro example.xlsx

[jindon]

Alter if needed.

Please Login or Register  to view this content.

[aimeecrystalaid]

awesome! that worked perfectly thank you

if you don't mind, could you quickly explain how this macro works? i may have similar data later but with slight changes so might need to alter it if i can

[jindon]

1)

Please Login or Register  to view this content.

This gives you the areas(block of range) that has constant values. 2 = xlConstants.
You will see the range adding one line

Please Login or Register  to view this content.

2) Loop thrugh 1) and output each range to other range transposing column to row(s).

Any question?