Creating one row of information in excel using a unique value

Posted by user1426513 on Stack Overflow See other posts from Stack Overflow or by user1426513
Published on 2012-05-30T16:38:48Z Indexed on 2012/05/30 16:40 UTC
Read the original article Hit count: 242

Filed under:

uniqueidentifier

|

mergesort

This is my first post. I am currently working on a project at work which requires that I work with several different worksheets in order to create one mail master worksheet, as it were, in order to do a mail merge. The worksheet contains information regarding different purchases, and each purchaser is identified with their own ID number. Below is an example of what my spreadsheet looks like now (however I do have more columns):

ID Salutation Address ID Name Donation ID Name Tickets 9 Mr. John Doe 123 12 Ms. Jane Smith 100.00 12 Ms.Jane Smith 300.00 12 Ms. Jane Smith 456 22 Mr. Mike Man 500.00 84 Ms. Jo Smith 300.00

What I would like to do is somehow sort my data so that everythign with the same unique identifier (ID) lines up on the same row. For example ID 12 Jane Smith - all the information for her will show up under her name matched by her ID number, and ID 22 will match up with 22 etc...

When I merged all of my spreadsheets together, I sorted them all by ID number, however my problem is, not everyone who made a donation bought a ticket or some people just bought tickets and nothing us, so sorting doesn't work.

Hopefully this makes sense.

Thanks in advance.

© Stack Overflow or respective owner

Related posts about uniqueidentifier

ASP.NET Conversion failed when converting from a character string to uniqueidentifier

as seen on Stack Overflow - Search for 'Stack Overflow'
hey all, i have a table which has a primary key (UserID) this is of type UniqueIdentifier. im trying to insert a value into this field but i keep getting an error. i want to get the userID of the current user and insert the into the user_Details table, but i keep getting this error Conversion… >>> More
From varchar(36) to UNIQUEIDENTIFIER

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to cast an AuctionId that is a UNIQUEIDENTIFIER to an varchar(36) and then back to an UNIQUEIDENTIFIER. Please help me. CAST((SUBSTRING(CAST([AuctionId] as VARCHAR(36)), 0, 35) + '1') AS UNIQUEIDENTIFIER) But I keep getting this error: Msg 8169, Level 16, State 2, Line 647 Conversion… >>> More
sql server change PK type from int to uniqueidentifier

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi! I need to change the type of my primary key column on a table from int to guid. The database already has data that I don't want to lose, and there are foreign keys to consider. Is there a painless way to do this or do I have to manually do it through a big a** script?:) I would appreciate any… >>> More
How to pass null for a parameter in stored procedure - the parameter is uniqueidentifier

as seen on Stack Overflow - Search for 'Stack Overflow'
In C# code I have a variable Guid? name.But,how to initialize this parameter to null,since I cannot assign null for a guid type >>> More
Isn't INT more efficient than UNIQUEIDENTIFIER?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a parent table and child table where the columns that join them together are the UNIQUEIDENTIFIER type. The child table has a clustered index on the column that joins it to the parent table (its PK, which is also clustered). I have created a copy of both of these tables but changed the relationship… >>> More

Related posts about mergesort

question about mergesort

as seen on Stack Overflow - Search for 'Stack Overflow'
i have write code on mergesort here is code public class mergesort{ public static int a[]; public static void merges(int work[],int low,int high){ if (low==high) return ; else{ int mid=(low+high)/2; merges(work,low,mid); merges(work,mid+1,high); merge(work,low,mid+1,high); } } public… >>> More
Mergesort : Revision

as seen on Stack Overflow - Search for 'Stack Overflow'
Does merge sort work by; taking a list of values splitting it in to two take the first element of each list, the lowest value one goes in to a new list(and i guess removed from the original). comare the next two numbers - do this until one list is empty, then place the rest of the other list at… >>> More
Problem with Mergesort in C++

as seen on Stack Overflow - Search for 'Stack Overflow'
vector<int>& mergesort(vector<int> &a) { if (a.size() == 1) return a; int middle = a.size() / 2; vector<int>::const_iterator first = a.begin(); vector<int>::const_iterator mid = a.begin() + (middle - 1); vector<int>::const_iterator last = a… >>> More
Using Mergesort to calculate number of inversions in C++

as seen on Stack Overflow - Search for 'Stack Overflow'
void MergeSort(int A[], int n, int B[], int C[]) { if(n > 1) { Copy(A,0,floor(n/2),B,0,floor(n/2)); Copy(A,floor(n/2),n-1,C,0,floor(n/2)-1); MergeSort(B,floor(n/2),B,C); MergeSort(C,floor(n/2),B,C); Merge(A,B,0,floor(n/2),C,0,floor(n/2)-1); } }; void Copy(int A[], int startIndexA… >>> More
Merge sort. ArrayIndexOutOfBoundsException [migrated]

as seen on Programmers - Search for 'Programmers'
When I execute the program I am getting an error as stated below the program. Please help me figure out the problem.. import java.util.*; class Mergesort { public static void main(String args[]) { Scanner in= new Scanner(System.in); System.out.println("Enter the number of elements"); … >>> More