Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Tables to summarise a column in one row?
I have a column with a list of names in, and then in the other two
columns a list of attriubutes for that person. The number of attributes could change, how can i simply get a single name entry with the attributes listed in a row. i.e Name Subject Grade John English A Maths B Jane English B German C Maths B Would be: John English A Maths B Jane English B German C Maths B Cheers Rich |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Tables to summarise a column in one row?
Public Sub ProcessData()
Dim i As Long Dim LastRow As Long With ActiveSheet LastRow = .Cells(.Rows.Count, "B").End(xlUp).Row For i = LastRow To 1 Step -1 If .Cells(i, "A").Value = "" Then .Cells(i, "B").Resize(, 100).Copy .Cells(i - 1, "D") .Rows(i).Delete End If Next i End With End Sub -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Richhall" wrote in message ... I have a column with a list of names in, and then in the other two columns a list of attriubutes for that person. The number of attributes could change, how can i simply get a single name entry with the attributes listed in a row. i.e Name Subject Grade John English A Maths B Jane English B German C Maths B Would be: John English A Maths B Jane English B German C Maths B Cheers Rich |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Pivot tables column headings | Excel Discussion (Misc queries) | |||
Pivot tables and column data | Excel Discussion (Misc queries) | |||
Pivot Tables and Column Labels | Excel Discussion (Misc queries) | |||
Column Resizing and Pivot Tables | Excel Discussion (Misc queries) |