I have a spreadsheet with two columns and a ton of rows. The rows are really should be the headers.
Column A has a series of items, Date, Name, Event Date, Email. and then in B the response to those. But I can't get the pivot table if that is what I am supposed to be using to cancel out the repeats in A and put the corresponding Text in B as Rows.