+ Reply to Thread
Results 1 to 3 of 3

Create column from uneven rows

  1. #1
    Registered User
    Join Date
    07-05-2022
    Location
    Virginia, USA
    MS-Off Ver
    365 Subscription (Mac and PC)
    Posts
    20

    Create column from uneven rows

    Hi there,

    I am looking to have a column created with all the Sundays in a year, however not every month has four Sunday's so I have 3 or 4 rows with five pieces of information. Is there a way I can convert a table to columns (I normally use transpose), but this does not move them into one column and there would be blanks.

    Thanks,
    Attached Files Attached Files
    Last edited by thomas.rickard; 07-14-2022 at 08:23 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2406 (Windows 11 23H2 64-bit)
    Posts
    82,642

    Re: Create column from uneven rows

    Where have you mocked up what you want?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,155

    Re: Create column from uneven rows

    How about in A4
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    and then in A5 dragged down
    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Transposing multiple uneven rows in columns for each unique name in column A
    By didierk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-07-2022, 02:42 PM
  2. Cant Tranpose with uneven rows
    By Vinicius Maito in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-19-2019, 12:26 AM
  3. [SOLVED] Combine even and uneven rows from different spreadsheets
    By JohanMa in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-20-2012, 10:51 AM
  4. Running formula with uneven number of rows
    By jacquiG in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-18-2012, 04:56 AM
  5. Vlookups for uneven rows?
    By mack zilla in forum Excel General
    Replies: 4
    Last Post: 07-10-2012, 03:31 PM
  6. Search rows in a table with uneven rows
    By lkkpederson in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-21-2010, 08:11 PM
  7. Copying only uneven rows
    By Vinoveritas in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-13-2009, 07:54 AM

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