locked
Converting lines into columns RRS feed

  • Question

  • Hello,

    In my mind, it seems to be easy but yet I am not able to make it work.

    It it very similar to the Pivot but not exactly the same

    Here is my raw data.

    Column1     Column2     Column3

    5390U29     Chair          9:20:21

    5390U29     Chair          9:45:48

    2410U24     Chair          10:14:12

    2410U24     Chair          10:25:11

    2410U24     Chair           10:55:36

    What I need is to regroup by column 1 & 2, and put every different time from column 3 in a new column

    Colum1       Column2   Column3    Column4     Column5

    5390U29     Chair        9:20:21     9:45:48

    2410U24     Chair       10:14:12     10:25:11    10:55:36

    I can have a thousand different times, but I need 8 new columns to push the data into them

    Anyone could help?

    Thanks a lot !!

    Monday, June 3, 2019 6:46 PM

Answers

All replies