Take formatted results and sort and place sorted list on new sheet.

edscollects

New Member
Joined
Feb 8, 2023
Messages
36
Office Version
  1. 2021
Platform
  1. Windows
I have this sheet that I am currently working on. What I am looking to accomplish is each row from column er to the furthest to the right is a timeline for the school in column A. On a separate sheet I want to take to take each unique listing from the columns er to the right and combine them together with the name in column A. This is what I am trying to accomplish visually. This would be a listing compiled for each unique cell. Thank you in advance.
01ACC
Clemson 1960-2023
Duke 1960-2023
Georgia Tech 1960-2014



NCAA 2-11-23.xlsm
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
Hello. Add this code to Module1 and run.

VBA Code:
Sub Combine()
    Dim lastRow, lastColumn As Long
    Dim i As Integer
    Application.ScreenUpdating = False
    Worksheets("Sheet1").Activate
    lastRow = ActiveSheet.Cells(ActiveSheet.Rows.Count, "A").End(xlUp).Row
    For i = 2 To lastRow
        lastColumn = ActiveSheet.Cells(i, ActiveSheet.Columns.Count).End(xlToLeft).Column
        ActiveSheet.Cells(i, 16384).Value = ActiveSheet.Cells(i, 1).Value & " " & ActiveSheet.Cells(i, lastColumn).Value
    Next i
    ActiveSheet.Range(Cells(2, 16384), Cells(lastRow, 16384)).Select
    Selection.Cut
    Sheets.Add
    ActiveSheet.Paste
    Application.CutCopyMode = False
    Columns(1).AutoFit
    ActiveSheet.Cells(1, 1).Select
    Application.ScreenUpdating = True
End Sub
 
Upvote 0
When running after changing to 10000 it shows up like this:
Georgia Tech 1960-64
Maryland 1960-2014
instead of
01ACC
Georgia Tech 1980-2023
Maryland 1960-2014
It looks like it is only showing the entry furthest to the right.
 
Upvote 0

Forum statistics

Threads
1,223,234
Messages
6,170,891
Members
452,366
Latest member
TePunaBloke

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top