Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding a unique identifier to a column of data
I have a spreadsheet of data I exported from a Loutus Notes folder that
unfortunately I can only get in this format: First: Fred Last: Flintstone Title: Controller First: Betty Last: Rubble Title: Analyst First: Donald Last: Duck Title: VP Is there a function I could use to fill in some kind of unique identifier in a column so I can turn these into records with a pivot table? Like this: A First: Fred A Last: Flintstone A Title: Controller B First: Betty B Last: Rubble B Title: Analyst C First: Donald C Last: Duck C Title: VP Or any other ideas? I want to end up with: First Last Title Fred Flintstone Controller Betty Rubble Analyst Donald Duck VP Thanks for any ideas and help! Holly |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding data to existing data that has a unique number in column | Excel Discussion (Misc queries) | |||
Selecting only rows of data with unique identifier | Excel Discussion (Misc queries) | |||
Combine data from 2 worksheets using unique identifier | Excel Worksheet Functions | |||
Unique identifier | Excel Discussion (Misc queries) | |||
Unique identifier | Excel Worksheet Functions |