Results 1 to 12 of 12

Splitting Columns into Multiple

Threaded View

  1. #1
    Registered User
    Join Date
    02-02-2024
    Location
    Glasgow, Scotland
    MS-Off Ver
    365
    Posts
    44

    Splitting Columns into Multiple

    Hopefully this can be done without a Macro?

    Using Power Query, I get a result with 3 columns, and varying number of rows.

    This is then going to be linked to a PowerPoint document, but the number of rows is too many to fit and be readable on a single slide. We are currently manually moving a group of cells around to make it look better before pasting onto the slide. All other slides are linked back to the workbook so just needs a refresh..

    is there a way to split by say 30 rows into as many columns as need?

    Sample file enclosed.

    thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] splitting row into multiple columns
    By kisanvikas2015 in forum Excel General
    Replies: 8
    Last Post: 04-25-2015, 06:03 AM
  2. Splitting a list of data into multiple columns
    By achhun02 in forum Excel General
    Replies: 1
    Last Post: 03-18-2015, 04:51 PM
  3. Splitting multiple entries in single cell into multiple columns
    By David_Mitchell in forum Excel General
    Replies: 12
    Last Post: 01-24-2013, 06:57 AM
  4. [SOLVED] Excel 2007 : splitting data into multiple columns
    By SubtleFudge in forum Excel General
    Replies: 3
    Last Post: 07-17-2012, 02:21 PM
  5. Splitting a column in CSV to multiple columns
    By Nehalem in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-04-2012, 07:08 AM
  6. Splitting address into multiple columns
    By susriram in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-07-2011, 02:02 PM
  7. Splitting one column into multiple columns
    By paintermonkey@gmail.com in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-02-2006, 03:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1