+ Reply to Thread
Results 1 to 3 of 3

Convert rows to columns

  1. #1
    Geno
    Guest

    Convert rows to columns

    I have a spreadsheet that has a list of companies and contacts within
    those companies. Some rows have one company with one contact for that
    company. Many rows have the same company info duplicated with a
    different contact info for that company. What I need is unique rows
    with unique company name and all the contacts for that company in the
    same row.


  2. #2
    Registered User
    Join Date
    08-23-2020
    Location
    Dhaka
    MS-Off Ver
    2016
    Posts
    23

    Re: Convert rows to columns

    First You need to create another Sheet. Just Remove the duplicate from Company Column and use function =Row(Filter)
    if you have any confusion kindly connect me.
    [link to external paid service site removed by Moderator]
    Last edited by 6StringJazzer; 08-23-2020 at 03:18 PM.

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,970

    Re: Convert rows to columns

    Sybon, this thread is 14 years old and an answer here is not likely to be helpful.

    We do not permit links to external paid services.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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