Excel to SPSS reformatting

I need someone to explain to me in simple terms how to reformat a table (with 1559 rows) in Excel so that I can apply the solution to a large dataset. Here is the issue: I have a dataset from Twitter which MAXQDA (Qualitative analysis tool) has exported coded segments to Excel in a stacked form, so that each instance of a code is in an individual row. My first problem is that for each tweet, I have duplicate rows (where every column is identical) which need to be counted and assigned to an individual tweet. For instance, if Tweet 1 contains five hashtags, I currently have five rows which are labelled ‘hashtag’ for that tweet. Instead, I need one column containing ‘Tweet 1’ and a second containing the number five. This should be fairly easy to solve in Excel. However, my second problem complicates matters. For each tweet, I have a total of 21 codes (e.g. video, image, text, URL) including ‘hashtag’, which are all stacked in these rows. I want to enter the data into SPSS for statistical analysis, so these codes need to be arranged into columns as well. I already know how to take the data from the stacked rows and arrange it in a single row with two columns, like this: ‘Tweet 1: Video, hashtag, hashtag.’ When I do this, my tweets have lists of different lengths, so the second row might read: ‘Tweet 2: Text, hashtag.’ Following this, if I try to make columns using this data, it gets arranged without considering the contents of each line. This means Column 1 is correct – with ‘Tweet 1’ above ‘Tweet 2’, but Column 2 now reads: ‘video’; ‘text’, Column 3: ‘hashtag’, ‘hashtag’, and Column 4 has 'hashtag' for Tweet 1 and nothing for Tweet 2. What I really need is a numerical count for each instance of a code in columns with headers that correspond to the data they represent. In this hypothetical example then, I am looking for four columns headed: Tweet number, video, text, hashtag. The rows should then read: Tweet 1: 1, 0, 2. Tweet 2: 0, 1, 1. I would like someone to help me with a solution on the first document - and inform me of the procedure so that I can apply it to subsequent documents.