Transposing specific duplicated column data into rows given ID #
Clash Royale CLAN TAG #URR8PPP Transposing specific duplicated column data into rows given ID # I have a data frame that consists of ID #'s in the first column and multiple transactions for that given ID. For example: ID Transaction 1111 $13 1111 $55 1111 $4 1112 $27 1112 $40 1113 $12 1114 $100 1114 $60 1114 $55 What I am trying to do is to have only one line of the Customer ID and then creating multiple transactions for each instance. For example: ID Transaction1 Transaction2 Transaction3 1111 $13 $55 $4 1112 $27 $40 1113 $12 1114 $100 $60 $55 Any help would be appreciated. I've been trying to use for loops and what not but I keep getting lost in my work and have been looking for an easier way to do this. Possible duplicate of How to reshape data from long to wide format? – Rui Barradas 5 mins ago ...