Closed Thread
Results 1 to 2 of 2

Combine data in 2 rows into 1 single row

  1. #1
    Registered User
    Join Date
    09-28-2022
    Location
    Perth
    MS-Off Ver
    O365
    Posts
    29

    Combine data in 2 rows into 1 single row

    HI

    I got data of matches played in 2 separate rows with different formatting.
    I want to combine the data in 1st row and 2nd row together as shown in second tab - "Formulate here"

    Could you please?
    Thank you
    Attached Files Attached Files

  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. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,933

    Re: Combine data in 2 rows into 1 single row

    Administrative Note:

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-gen...nised-one.html
    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.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to combine data from multiple rows into a single row / multiple columns
    By Iain170 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-17-2020, 06:56 AM
  2. [SOLVED] Formula to Combine Multiple Rows into a single row of data
    By sherylt13 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-17-2017, 10:12 PM
  3. Combine Data in Multiple Rows into Single Row
    By koonwei605 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-18-2014, 07:43 AM
  4. Replies: 6
    Last Post: 02-19-2014, 10:25 AM
  5. combine nmultiple rows of data to single
    By supert8ch in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-05-2013, 08:49 AM
  6. Combine multiple rows into a single row with concatenation
    By MichaelWood in forum Excel General
    Replies: 7
    Last Post: 06-30-2012, 01:49 PM
  7. How to combine several Rows in excel into a single row.
    By Vadimchik in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-06-2012, 03:39 AM

Tags for this Thread

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