Split The Range

[Klitos]

Hi,

I have a range that i want to split in single rows.
See attach.
Sample.xlsx

Thanks
K.

[:) Sixthsense :)]

Can you give brief about which range and show the outcome too for better understanding of your requirement

[Richard Buttrey]

Hi,

Not sure what you mean. All the data records are already single rows. If you want to remove blank rows then filter one of the columns for blanks, select all the filtered rows and delete them.

[Klitos]

Thanks for the answers.

I make a mistake about the atachements.
This is the correct one..
Sample.xlsx

Thanks
K.

[:) Sixthsense :)]

Hm.. again no brief about the data and the expected outcome

[Klitos]

Hm.. again no brief about the data and the expected outcome

Ok i have highlighted the outcome with green color. I think now is clear.
Sample.xlsx

Thanks
K.

[:) Sixthsense :)]

In C2 Cell

Please Login or Register  to view this content.

[mnjofra]

Hi Klitos,
I think that understand your question.
Look on the attached file, is it solution in column D ?
Column C is added for temporary shape of data, and column D has correctly placed result, I think.

Regards,

[Klitos]

Hi Klitos,
I think that understand your question.
Look on the attached file, is it solution in column D ?
Column C is added for temporary shape of data, and column D has correctly placed result, I think.

Regards,

The C column is the range that i have to create after in column D. So the results is 2! First is the column C and then the D column.

[Klitos]

Steps.png
The picture shows the steps.

[Klitos]

any ideas???