Forum Discussion
Solved
Spreading data contained in column A across to other columns to form a table
I have a copy and paste multi-line data from a web page which has all gone into column A. This isn't a text to column use case but one where I want to place data from column A into relevant headed ...
- Which solution is now appropriate to your desire?
Please do not forget that the VBA solution leaves one line free every 10 rows, so that all addresses of the column in the row can be kept apart.
If you find this helpful, please mark it as "Best Answer" and as Like (click thumbs up), it will be beneficial to more Community members reading here.
Nikolino
I know I don't know anything (Socrates)
Although there is a lot built in with Power Query, here is a small additional solution with VBA ... simple but effective.
Open with the worksheet and press the button. If you press it several times, you will see that it can continue to enter as you imagine.
Open with the worksheet and press the button. If you press it several times, you will see that it can continue to enter as you imagine.
NikolinoDE Thanks...I think the translation from German to English did not make complete sense. Thanks for your help anyway! M
- Which solution is now appropriate to your desire?
Please do not forget that the VBA solution leaves one line free every 10 rows, so that all addresses of the column in the row can be kept apart.
If you find this helpful, please mark it as "Best Answer" and as Like (click thumbs up), it will be beneficial to more Community members reading here.
Nikolino
I know I don't know anything (Socrates)NikolinoDE Thank you...