I have rows of data in AdminSheet and want to insert those into Main Data Table but it needs to be in that one column and have the spaces to look good. I found a script online that would re-order them into one column but it took out all the spaces and it didn't fit the format.

closed as unclear what you're asking by Rubén, serenesat, jonsca Oct 17 '17 at 22:52

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • 3
    Some screenshots would probably be very helpful to illustrate what you are trying to show in the sample sheet. – jonsca Oct 13 '17 at 0:26

You can do this using join and split, and transpose like this:

=transpose(split(join(rept(" ;",5),indirect("A1:A"&counta(A1:A))),";"))

enter image description here

Not the answer you're looking for? Browse other questions tagged or ask your own question.