Is there any way to paste 16000 numbers so it will flow into 16 columns, 1000 in each.

[Beljandi]

Hello everyone.

Is there any way to paste 16000 barcode numbers so it will flow into 16 columns, 1000 in each.

Thank you in advance.

[CK76]

To my knowledge, it would require VBA, or some other method of transforming data (such as PowerQuery).

You can't just copy and paste special to do what you are looking for.

[CAntosh]

Welcome to the forum!

Paste your list into column A of one sheet (called "PasteList" in the attachment), then use the following formula in A1 of another sheet:

=INDEX(PasteList!$A:$A,(COLUMN()-1)*1000+ROW())

Fill right 16 columns and down 1000 rows. If you want numbers instead of formulas, just copy the results and pastevalues over them. See the attachment for a demonstration - or just replace the list on PasteList with your own:

[Beljandi]

CAntosh. Thank you so much. This works fine and I can stop dreaming about copy-paste everynight. Thanks again!

[CAntosh]

Glad to help, good luck!