I have many rows that I need to combine into one row. They have a same value in common.
It looks something like this.
271001 0033 02 Atty Floyd Fortuin TTE
271001 0049 02 Cleared Mark Itkowitz
271001 0053 03 RM CB Develop Sales Inc
271001 0056 03 DL MMRC LLC
I need it to look like this.
271001 0033 02 Atty Floyd Fortuin TTE 271001 0049 02 Cleared Mark Itkowitz 271001 053 03 RM CB Develop Sales Inc 271001 0056 03 DL MMRC LLC
I need the values to be transposed to the next available cell on the first row.
Thank you,
Bookmarks