Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: Placing Row Titles in Rows Below

  1. #1
    New Member
    Join Date
    Sep 2019
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Placing Row Titles in Rows Below

    Good Afternoon All;

    I am running into an issue I can't resolve with a data export. The data exports with what I suppose would be called a "Header" row, with the corresponding data in the rows beneath. There is no certain number of rows beneath, and due to the size of the file I can't do this manually. I am attempting to get all of the relevant data in a single row, but no solutions are coming to me. I have placed a crude example below (first post, still learning the example upload).

    Current Situation:

    Apples
    John Smith / 5 Bushels / 7-5-2016

    Needed Situation:

    Apples/ John Smith / 5 Bushels / 7-5-2016

    Anything you can think of would be a huge help; I've hit a complete wall on this one.

  2. #2
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,201
    Post Thanks / Like
    Mentioned
    470 Post(s)
    Tagged
    47 Thread(s)

    Default Re: Placing Row Titles in Rows Below

    Whilst this is almost certainly do-able, we would need to see some accurate examples of exactly how your data is laid out.
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  3. #3
    New Member
    Join Date
    Sep 2019
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Placing Row Titles in Rows Below

    A B C D E F G H I J K L M N O P Q R S T U V W X
    1 Header Row 1
    2 Row That Needs Header xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx
    3 Row That Needs Header xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx
    4 Header Row 2
    5 Row That Needs Header xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx
    6 Header Row 3
    7 Row That Needs Header xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx
    Sheet1
    Example listed above; please let me know if I can provide any additional information. Thank you so much for replying!

  4. #4
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,201
    Post Thanks / Like
    Mentioned
    470 Post(s)
    Tagged
    47 Thread(s)

    Default Re: Placing Row Titles in Rows Below

    How should that end up looking?
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  5. #5
    New Member
    Join Date
    Sep 2019
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Placing Row Titles in Rows Below

    Ideally the data in Row 1, Column A would be in a cell in rows 2 and 3; the data in Row 4, column A would be in a cell in row 5, and the data in row 6, column A would be in a cell in row 7

  6. #6
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,201
    Post Thanks / Like
    Mentioned
    470 Post(s)
    Tagged
    47 Thread(s)

    Default Re: Placing Row Titles in Rows Below

    Is column A blank other than the header rows?
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  7. #7
    New Member
    Join Date
    Sep 2019
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Placing Row Titles in Rows Below

    Yes, other than a small descriptor in that row that I will probably just remove using a "Find and Replace", the row is otherwise empty

  8. #8
    New Member
    Join Date
    Sep 2019
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Placing Row Titles in Rows Below

    Correction: Row 1; column A does have data in the subsequent rows. The Rows with the header are blank, however, with the exception of the piece of data i'm moving.

  9. #9
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,201
    Post Thanks / Like
    Mentioned
    470 Post(s)
    Tagged
    47 Thread(s)

    Default Re: Placing Row Titles in Rows Below

    So if column A has data, what do you want to do with that?
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  10. #10
    New Member
    Join Date
    Sep 2019
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Placing Row Titles in Rows Below

    I would need that moved to another cell (Maybe push the row one to the left and have the former header in the column A location, if possible)

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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