Split Long Data in Multiple Columns (by 1 click)

0 Rows

Split Long Data in Multiple Columns


Got one long list that runs hundreds of rows down a single column? This tool rearranges it into as many columns as you choose, so it fits on one printed page or drops neatly into a spreadsheet.

How it works

  1. Paste your list into the box, one item per line. The counter at the top shows how many rows you’ve added.
  2. Set Number of Columns. It starts at 4.
  3. Click Convert, then Copy Data and paste the result into Excel or Google Sheets.

When people use it

  • Turning a long list of names into a compact sign-in sheet
  • Fitting product codes or SKUs onto one page for a stock check
  • Laying out a seating or roll-call list in rows

Example

Six items (A to F) split into 3 columns fill each column from top to bottom: A and B in the first column, C and D in the second, E and F in the third.

Tips

Remove blank lines before you convert, or they will show up as empty cells. The Remove Blank Lines tool does that in one click. If you’d rather do it inside Excel, the WRAPROWS function in Microsoft 365 gives a similar result.

Made by Nazim Khan, an MBA (Finance) and Excel trainer with 10+ years in accounts and MIS. Last updated November 18, 2026.

Leave a Comment