+ Reply to Thread
Results 1 to 4 of 4

A formula to generate three more words in separate columns from a list provided.

  1. #1
    Registered User
    Join Date
    08-18-2020
    Location
    Valencia
    MS-Off Ver
    Mac excel - Office 365 - v 16.72
    Posts
    61

    A formula to generate three more words in separate columns from a list provided.

    Hi. I need a formula in excel that creates the following. I only have a list of words in column A. I am creating a quiz with these words.

    abandoned absolute abstract absurd
    absolute abstract absurd academic
    abstract
    absurd
    academic
    accessible


    I have a list of words in column A.
    I need to generate 3 more words in columns B, C, D.
    The 3 words used are the ones directly below the word in A so sequentially taken.

  2. #2
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,897

    Re: A formula to generate three more words in separate columns from a list provided.

    try this,
    B1
    =INDEX($A:$A,ROW()+COLUMN()-1)&""

    copied down and across.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    08-18-2020
    Location
    Valencia
    MS-Off Ver
    Mac excel - Office 365 - v 16.72
    Posts
    61

    Re: A formula to generate three more words in separate columns from a list provided.

    Wow - that was amazing. You have saved me so many hours of work. I used to do it manually. I also tried in chatGPT but it was so buggy.
    Thank you my friend. I can't see where I am supposed to tick as correct answer.

  4. #4
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,897

    Re: A formula to generate three more words in separate columns from a list provided.

    You are welcome.

+ 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] formula to generate a separate list of only products ordered
    By Rod108 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-07-2022, 12:26 AM
  2. [SOLVED] Dates provided in One Column Move to Separate Columns
    By Bobbbo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-30-2021, 06:45 PM
  3. Replies: 4
    Last Post: 08-15-2018, 11:41 AM
  4. [SOLVED] Separate Words from List Into Columns
    By Patish in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-18-2016, 12:35 PM
  5. [SOLVED] Lookup/Match - Compare 1 list to 2 other lists based on 2 columns - example provided
    By D.Lovell in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-24-2015, 08:00 PM
  6. [SOLVED] Need to generate 3-character words from 3 columns
    By tmccar in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-17-2012, 07:13 AM
  7. Generate a separate small list from a large list
    By bprice in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-06-2012, 11:25 PM

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