+ Reply to Thread
Results 1 to 4 of 4

Multiple Value Text Table

  1. #1
    Registered User
    Join Date
    04-26-2020
    Location
    Edinburgh, Scotland
    MS-Off Ver
    365
    Posts
    3

    Multiple Value Text Table

    Hi guys
    I have a spreadsheet with three columns; email address, name, date of birth. There can be up to 3 names and dates of birth connected to each email. I need to make a table so the headers will be: email, name 1, dob 1, name 2, dob 2, name 3, dob 3. What is the easiest way to get this information?

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    2,022

    Re: Multiple Value Text Table

    Follow the instructions found above in the yellow banner
    Click the * to say thanks.

  3. #3
    Registered User
    Join Date
    04-26-2020
    Location
    Edinburgh, Scotland
    MS-Off Ver
    365
    Posts
    3

    Re: Multiple Value Text Table

    Apologies, attached
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    10,502

    Re: Multiple Value Text Table

    The formula for distinct email addresses could be (paste into cell A2 and then copy down):
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    The formula for names and DOB's could be (paste into cell B2 and then copy down and across):
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Note that DOB columns will need to be formatted as date.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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] Pivot Table count of multiple columns with same text
    By bigtrev2 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-26-2017, 05:52 PM
  2. [SOLVED] List of text from table based on multiple criteria
    By Jkaen in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-15-2016, 06:53 AM
  3. Replies: 6
    Last Post: 08-19-2015, 07:46 PM
  4. [SOLVED] Multiple Text Search Within Cell of Table
    By rarascon in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-11-2014, 07:40 AM
  5. Consolidate text data from multiple tabs into one table
    By neversummer515 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 02-01-2013, 05:52 PM
  6. Multiple pivot table filter on cell text
    By jsegner in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-13-2012, 06:12 PM
  7. Need Multiple Text Filters in Pivot table
    By b_vasu in forum Excel General
    Replies: 2
    Last Post: 11-24-2010, 03:19 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