+ Reply to Thread
Results 1 to 2 of 2

Data in multiple columns into singular column....

  1. #1
    Forum Contributor
    Join Date
    07-16-2014
    Location
    Yorkshire
    MS-Off Ver
    MS 10
    Posts
    100

    Data in multiple columns into singular column....

    Hi all,

    Hope you are well,

    I have this issue, and wondered if anyone can help me solve it in a simplistic way.

    Copy pasting will take forever.

    I have attached a spreadsheet that hopefully shows the issue that I am trying to overcome.

    Data spread by option across columns F-AO, I would like to present in columns B-E, with reference to the option in column A.

    Thanks
    seash
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Data in multiple columns into singular column....

    Please try at B5

    =IF($A5="","",INDEX($F5:$ZZ5,MATCH($A5,$F$3:$ZZ$3,)-1+COLUMNS($B5:B5)))
    Attached Files Attached Files

+ 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. need help with a VBA code to search multiple criteria for singular result
    By txsooner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-28-2020, 04:17 PM
  2. Finding Only Singular Instances of a Value in a Column
    By Not Excelling 88 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-10-2020, 12:28 PM
  3. Replies: 6
    Last Post: 11-25-2015, 01:01 PM
  4. [SOLVED] How to make a singular macro apply to multiple cells?
    By Lowa in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-18-2015, 10:26 AM
  5. Combining data in multiple columns(all columns have same length)into one column
    By nzi0001 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 07-24-2014, 11:19 AM
  6. [SOLVED] Convert column B as multiple column titles and move data in column C into new columns?
    By princesscathryn in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 06-30-2014, 07:31 PM
  7. Lookup Data in One Column, Find Multiple Entries in Next, Copy to Multiple Columns
    By nzxt1234 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-16-2010, 01:17 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