+ Reply to Thread
Results 1 to 4 of 4

[Help] Coincidence data in the columns align it in the same row

  1. #1
    Registered User
    Join Date
    10-29-2014
    Location
    Japan
    MS-Off Ver
    2007
    Posts
    6

    Question [Help] Coincidence data in the columns align it in the same row

    I would like to organize this data in the way explained bellow.
    \1

    What I am would like to do is that if there is any coincidence in the columns, align it in the same row, leaving blank spaces if there is no coincidence.
    I make an example of what I would like to do writing it manually in the cells.
    \1

    Does anyone know how to do this in excel?
    If anyone could help me I would be very grateful. Thank you in advance

  2. #2
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,067

    Re: [Help] Coincidence data in the columns align it in the same row

    Hi h2ojuan,

    Rather than ask the forum members to go & look at links to see what you want, explain your problem & attach an example file.
    Remember you are unique, like everyone else

  3. #3
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: [Help] Coincidence data in the columns align it in the same row

    Hi, ref the attachment, Labelled values as rows, and put a PivotTable using multiple cons ranges.
    Attached Files Attached Files
    Click just below left if it helps, Boo?ath?

  4. #4
    Registered User
    Join Date
    10-29-2014
    Location
    Japan
    MS-Off Ver
    2007
    Posts
    6

    Re: [Help] Coincidence data in the columns align it in the same row

    Sorry I am new and I didn't know I can upload files.
    I have uploaded the file Organize Columns.xlsx, in the first sheet I have the data and in the second sheet I wrote how I would like to display it. If anyone could explain it I would be very grateful.

    boopathiraja, Thank you very much for your help.

    Please Login or Register  to view this content.
    Sorry could you explain it more simple? I made the PivotTable, then what should I do?
    Thank you in advance.

+ 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. Align data in columns by last row
    By kkl234 in forum Excel General
    Replies: 2
    Last Post: 01-30-2014, 10:51 PM
  2. [SOLVED] Align 3 columns with 2 columns of matching data
    By loritee in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-23-2013, 10:36 AM
  3. VBA to align data in columns
    By cloudwalking in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-25-2013, 11:07 AM
  4. [SOLVED] Align data in different columns
    By Lozhaze in forum Excel General
    Replies: 7
    Last Post: 07-19-2012, 09:47 AM
  5. Align Data in Columns
    By donnydorko in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-18-2009, 01:18 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